Access中用between查询某时间段内的记录

sqlserver中：select * from tab1 where dt between '2011-01-01' and '2012-01-01'

Access中：select * from tab1 where dt between #2011-01-01# and #2012-01-01#