求助：余额查询设计

将1楼主的查询改为联合查询就能实现.

我这边没办法上传压缩文件

SELECT 余额查询.ID, 余额查询.年, 余额查询.月, 余额查询.公司名, 余额查询.银行名称, IIf(IsNull([收入]),0,[收入]) AS 收入1, IIf(IsNull([支出]),0,[支出]) AS 支出1, [收入1]-[支出1] AS 余额
FROM 余额查询;
UNION
SELECT "汇总" AS ID, Null AS 年, Null AS 月, Null AS 公司名, 余额查询.银行名称, Sum(IIf(IsNull([收入]),0,[收入])) AS 收入1, Sum(IIf(IsNull([支出]),0,[支出])) AS 支出1, [收入1]-[支出1] AS 余额
FROM 余额查询
GROUP BY Null, Null, Null, Null, 余额查询.银行名称;