修改下SQL语句
select 名称,编号,sum(sl) as 数量,sum(je) as 金额
from shop_action
where
datediff('d',fhsj,"&day2&")>=0
and
datediff('d',"&day1&",fhsj)<=0
and
bookid="&rs("bookid")
group by 名称,编号
*说明
名称,编号，这些字段换成你数据表实际的字段名称
汇总就在语句里面实现，然后页面在循环输出即可
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024