Access如何将两个交叉查询表合成一个带列汇总的表？

请求帮助！用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\月");

img


查询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\月");

img

最终想要实现交叉查询1的效果如图：

img