请求帮助!用Access将交叉查询表2和交叉查询表3合成一个交叉查询表1,在最后一行统计列总和,不知到如何使用UNION ALL语句连接。
查询2:
TRANSFORM Sum(A.数量) AS 合计
SELECT A.类型, Sum(A.数量) AS 数量之合计
FROM A
WHERE (Format([时间],"y"))=Format(Now(),"y")
GROUP BY A.类型
PIVOT Format([时间],"mm\月");
查询3:
TRANSFORM Sum(A.数量) AS 合计
SELECT Format([时间],"y") AS 年份, Sum(A.数量) AS 数量之合计
FROM A
WHERE (Format([时间],"y"))=Format(Now(),"y")
GROUP BY Format([时间],"y")
ORDER BY Format([时间],"y") DESC
PIVOT Format([时间],"mm\月");