Acess日期范围查询不同于SQL,需要在前面和后面都加上#号
select * from info where sn_no like '%AA%' And Op_Date>=#2014-03-27# And Op_Date<=#2014-03-27#
Acess日期范围查询不同于SQL,需要在前面和后面都加上#号
select * from info where sn_no like '%AA%' And Op_Date>=#2014-03-27# And Op_Date<=#2014-03-27#