摘要：
Access中不支持Case when语法，可用iif如：select id,num,dt,username, iif(dxaction , '还' , '取' ) AS dxaction from dxaction；注：dxaction字段本身为bool类型select iif(sex= '1 ', '男 ', '女 ') from tt帮助说明：用 SWITCH 函数也可以，如select switch(fieldname= 'a ', '您选择了选项1 ',fieldname= 阅读全文
摘要：
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# 阅读全文