select * from tt where f1
between #2007-04-21 0:00:00# and #2007-04-24 23:59:59#
上述是最有效率的
如果一定要用日期,可以这么做,也是最有效率的
select * from tt where f1
between cdate( "2007-04-21 " & " 0:00:00 ") and cdate( "2007-04-24 " & " 23:59:59 " )
請參考:
http://community.csdn.net/Expert/topic/5429/5429916.xml?temp=.8885157