SQL语句

SELECT 进货明细表.进货月份1, Sum(进货按月份统计表.进货上月欠款总余额) AS 进货欠款总余额, Sum([进货数量(吨)]*[进货单价]) AS 进货总金额, DSum("进货还款金额","进货还款明细表","进货还款月份1='" & [进货月份1] & "'") AS 进货还款总金额, Sum(进货按月份统计表.进货上月欠款总余额)+Sum([进货数量(吨)]*[进货单价])-DSum("进货还款金额","进货还款明细表","进货还款月份1='" & [进货月份1] & "'") AS 进货本月欠款累计金额
FROM 进货明细表
And FROM 进货按月份统计表
GROUP BY 进货明细表.进货月份1
HAVING ((Not (进货明细表.进货月份1) Is Null));

在进货明细表 和 进货按月份统计表 中请帮修改一下如上代码

点击下载此附件