上月:
------------------
select * from bjbb where (datediff("d",DateAdd("m",-2,Now),riqi)>0) and (datediff("d",riqi,DateAdd("m",-1,Now))>=0)
本年1月到上个月的数据
-----------------------
select * from bjbb where (datediff("d",CDate(year(Now)&"-1-1"),riqi)>=0) and (datediff("d",riqi,DateAdd("m",-1,Now))>=0)
去年1月到去年这个时候的上个月
-----------------------
select * from bjbb where (datediff("d",CDate(year(DateAdd("yyyy",-1,Now))&"-1-1"),riqi)>=0) and (datediff("d",riqi,DateAdd("m",-13,Now))>=0)
本年1月到上月的数据
-----------------------
select * from bjbb where (datediff("d",CDate(year(Now)&"-1-1"),riqi)>0) and (datediff("d",riqi,DateAdd("m",-1,Now))>=0)
上月:
------------------
select * from article where (datediff("d",DateAdd("m",-2,Now),dateandtime)>0) and (datediff("d",dateandtime,DateAdd("m",-1,Now))>=0)