|
楼主 |
发表于 2014-4-15 10:34
|
显示全部楼层
[广告] VBA代码宝 - VBA编程加强工具 · VBA代码随查随用 · 内置多项VBA编程加强工具 ★ 免费下载 ★ ★ 使用手册★
335081548 发表于 2014-4-15 10:25
分组的附件
select 日期,罐号,名称,sum(数量) as 数量 from
(
select 日期,罐号,名称,数量*1 as 数量 from (
select f1 as 日期,'A3001' as 罐号,f3 as 名称,f4 as 数量 from [入库表$a7:v37] union all
select f1 as 日期,'A3002' as 罐号,f6 as 名称,f7 as 数量 from [入库表$a7:v37]) where 名称
union all
select 日期,罐号,名称,数量*-1 as 数量 from (
select f1 as 日期,'A3001' as 罐号,f3 as 名称,f4 as 数量 from [出库表$a7:v37] union all
select f1 as 日期,'A3002' as 罐号,f6 as 名称,f7 as 数量 from [出库表$a7:v37]) where 名称
union all
select f1,f2,f3,f4 from [期初表$a2:d]
)
group by 日期,罐号,名称
order by 罐号,名称,日期
|
|