sql语句问题!! 大虾请进!
我要取出数据库中 KAIHU(时间字段,日期型)时间在 dtpicker1.value 和 dtpicker2.value 之间的记录.(数据库为ACCESS2000数据库)
我的sql="select * from TABLE where KAIHU between #" & dtpicker1.value & "# and #" & dtpicker2.value & "#"
但是结果不对. 后我又改为
sql="select * from TABLE where KAIHU between " & Cdate(dtpicker1.value) & " and " & Cdate(dtpicker2.value) & ""
结果还是不对。
又改为:
sql="select * from TABLE where KAIHU between #" & Cdate(dtpicker1.value) & "# and #" & Cdate(dtpicker2.value) & "#"
还是同样的错.帮帮我!!