Set DTPicker2=ScreenItems("控件2")
Set DTPicker3=ScreenItems("控件3")
time2=DTPicker2.value
time3=DTPicker3.value
sSql="SELECT * FROM zg WHERE 时间 between'"&time2&"' and '"&time3&"'"
用dtpicker控件按时间查询,查询的结果为空。但是同样的
Set DTPicker4=ScreenItems("控件4")
Set DTPicker5=ScreenItems("控件5")
time4=DTPicker4.value
time5=DTPicker5.value
sSql="SELECT * FROM zg WHERE 日期 between'"&time4&"' and '"&time5&"'"
按日期查询却可以