Select* From 表1 where rq betweendateadd( 'm',-1,datevalue(year(now())&"-"&month(now())&"-1")) anddateadd('d',-1,datevalue(year(now())&"-"&month(now())&"-1"))
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"))