小白请教进销存账户余额统计

仅供参考

SELECT qry账户.账户, Sum(qry账户.金额) AS 余额
FROM (
SELECT 充值.日期, 充值.金额, 充值.账户,"客户充值" as 取值表
FROM 充值
UNION ALL
SELECT 销售.日期, 销售.实收, 销售.账户,"销售收款" as 取值表
FROM 销售
UNION ALL
SELECT 内转.日期, 内转.金额, 内转.转入账户,"内部转入" as 取值表
FROM 内转
UNION ALL 
SELECT 内转.日期, [金额]*-1 AS 转出金额, 内转.转出账户,"内部转出" as 取值表
FROM 内转
UNION ALL 
SELECT 采购.日期, [实付]*-1 AS 采购支付, 采购.账户,"采购付款" as 取值表
FROM 采购
UNION ALL SELECT 收支.日期, 收支.金额, 收支.账户,"收支金额" as 取值表
FROM 收支
) qry账户
GROUP BY qry账户.账户