anjincheng你的代码我只能单个的算出数量,不能联合下面语句查询,但我还是谢谢你的帮助,谢谢!

sql="select paidan_name,count(bx_id) as danshu,sum(user_feiyong) as user_feiyong,sum((chuangshou))as chuangshou,sum(weixiu_feiyong) as  weixiu_feiyong,sum(paodanfei) as paodanfei from baoxiu  where  baoxiu_date  between #"&date1&"#  and  #"&DateAdd("d",1,date2)&"#  group by paidan_name "

头又疼了，.............

你这句也只能求出每个工程师的数据吧?
其实你总计根本没必要放在sql语句里面来完成,你把每个工程师的记录都查询出来,然后肯定要用循环来显示,在循环的时候,弄几个变量,然后累加起来就好了