|
图片
附件
ttach]246447[/attach]
本帖最后由 mxg825 于 2012-8-25 17:01 编辑
- sql = "select * from (" & _
- "select 货品编号,供应商,产地,品名,规格,sum(进货数量),单位,sum(进货总金额) from [sheet1$B4:K" & intRow & "]" & _
- "GROUP BY 供应商,货品编号,产地,品名,规格,单位" & _
- " UNION ALL " & _
- "select '',供应商,'','合计','',sum(进货数量),'',sum(进货总金额) from [sheet1$B4:K" & intRow & "]" & _
- "GROUP BY 供应商" & _
- ") ORDER BY 供应商,货品编号,品名 DESC"
复制代码替换一下 SQL 那一句就行了!
|
|