access2007下获得上个月的全部数据的sql语句

 

Select     *   
From    表1  
where    rq    between     dateadd (  ' m ' , - 1 ,datevalue( year (now()) & " - " & month (now()) & " - 1 "))    and     dateadd ( ' d ' , - 1 ,datevalue( year (now()) & " - " & month (now()) & " - 1 "))