查询与窗体

SELECT 进货明细表.进货月份1, Sum([进货数量(吨)]*20) AS [进货总数量(包)], Sum([进货数量(吨)]*[进货单价]) AS 总金额, DSum("进货还款金额","进货还款明细表","进货还款月份1='" & [进货月份1] & "'") AS 还款总额
FROM 进货明细表
GROUP BY 进货明细表.进货月份1
HAVING ((Not (进货明细表.进货月份1) Is Null));