str = "SELECT * FROM tab_data_conv WHERE starttime>" & DTPicker1.Value & " AND starttime < " & DTPicker2.Value
Set qdef = db.CreateQueryDef("", str)
我这么从一个库里选择日期字段满足条件的记录,Set语句不执行,为什么,着急等待
Set qdef = db.CreateQueryDef("", str)
我这么从一个库里选择日期字段满足条件的记录,Set语句不执行,为什么,着急等待
str = "SELECT * FROM tab_data_conv WHERE starttime>#" & DTPicker1.Value& "#" AND starttime <#" & DTPicker2.Value+“#”
str = "SELECT * FROM tab_data_conv WHERE starttime>#" & DTPicker1.Value& "#" AND starttime <#" & DTPicker2.Value & "# "
字符型则把#换成'
如果是数值型去掉#即可