select * from tb where _date between '2003-7-1' and '2003-7-3'
select * from tb where _date in ( '2003-7-1' ..'2003-7-3')
SQL Server数据库: select * from tb where _date between '2003-7-1' and '2003-7-3' Access数据库: select * from tb where _date between #2003-7-1# and #2003-7-3#
select * from tb where _date between '2003-7-1' and '2003-7-3'
Access数据库:
select * from tb where _date between #2003-7-1# and #2003-7-3#