set rs=...
sql="select sum(fzs),dealer_id from dealerfazhan where DateDiff(d,rq,用户输入的起始时间)>=0 and DateDiff(d,rq,用户输入的截止时间)<=0 group by dealer_id"
rs.open sql,conn, 1,1
do while not rs.bof
set rs1=...
sql1="select sum(fzs) from dealerfazhan where DateDiff(m,rq,用户输入的起始时间)=1 and dealer_id="& rs("dealer_id")'求上一个月,即环比
rs1.open sql1,conn, 1,1
set rs2=...
sql2="select sum(fzs) from dealerfazhan where DateDiff(y,rq,用户输入的起始时间)=1 and dealer_id="& rs("dealer_id")'求上一个月,即同比
rs2.open sql2,conn, 1,1
select dealer_id,
当期销售数=select count(*) from dealerfazhan where rq> 起始日期 And 终止日期<rq and dealer_id = a.id
上期销售数=select count(*) from dealerfazhan where (上期的时间条件) and dealer_id = a.id
去年同期销售数=select count(*) from dealerfazhan where (去年同期的时间条件) and dealer_id = a.id