access 按时间查询语句
偷麦 2011-12-06 01:35:31 想按照1号到30号这30天的销量查询 并且zhuangtai=1
SQL 怎么写
select distinct(action_dingdan),action_date,action_number,ticket_id,usersname,action_zhuangtai,action_zonger,renyuan,action_leixing,ticket_name,action_id from lhy_action where action_zhuangtai=1 and (format(action_date, "yyyy-mm-dd ") between #20111101# and #20111130#) order by action_id desc
我是这样写的 错了 求解