[Quote=引用 1 楼 wwwwb 的回复:]
SELECT *
FROM 查询29
union
select * from 查询31;
查询29:
TRANSFORM nz(sum([数量(f2)]),0)
SELECT [烟(1)], nz(sum([数量(f2)]),0) AS 小计
FROM ttb
GROUP BY [烟(1) ]
PIVOT [进货(f3)];
查询31:
TRANSFORM max(hj1)
SELECT hj, sum(hj1) AS 小计
FROM (SELECT [进货(f3)],1 as hj,nz(sum([数量(f2)]),0) as hj1
from ttb group by [进货(f3)])
GROUP BY hj
PIVOT [进货(f3)];
[Quote=引用 1 楼 wwwwb 的回复:]
SELECT *
FROM 查询29
union
select * from 查询31;
查询29:
TRANSFORM nz(sum([数量(f2)]),0)
SELECT [烟(1)], nz(sum([数量(f2)]),0) AS 小计
FROM ttb
GROUP BY [烟(1) ]
PIVOT [进货(f3)];
查询31:
TRANSFORM max(hj1)
SELECT hj, sum(hj1) AS 小计
FROM (SELECT [进货(f3)],1 as hj,nz(sum([数量(f2)]),0) as hj1
from ttb group by [进货(f3)])
GROUP BY hj
PIVOT [进货(f3)];
[/Quote]