请帮忙按客户各月小计和所有客户合计的查询,多谢！

供参考：

SELECT Sheet1.客户名称 AS 客户名称1, Sheet1.月份, Sheet1.[2013年12月底未收], Sheet1.金额, Sheet1.收款, Sheet1.欠款
FROM Sheet1;
 UNION all SELECT [客户名称] & "  合计" AS 客户名称1, " " AS 月份, Sum(Sheet1.[2013年12月底未收]) AS 2013年12月底未收, Sum(Sheet1.金额) AS 金额, Sum(Sheet1.收款) AS 收款, Sum(Sheet1.欠款) AS 欠款
FROM Sheet1
GROUP BY [客户名称] & "  合计";
UNION SELECT "总计" AS 客户名称1, " " AS 月份, Sum(Sheet1.[2013年12月底未收]) AS 2013年12月底未收, Sum(Sheet1.金额) AS 金额, Sum(Sheet1.收款) AS 收款, Sum(Sheet1.欠款) AS 欠款
FROM Sheet1;

点击下载此附件