[5分]计算问题

SELECT qry原料库存联合.代码ID, qry原料库存联合.原料仓库ID, qry原料库存联合.日期, Sum(qry原料库存联合.入库件数) AS 入库件数之合计, Sum(qry原料库存联合.出库件数) AS 出库件数之合计, DSum("入库件数之合计-出库件数之合计","qry原料库存信息","代码ID='" & [代码ID] & "' and 日期<=#" & 日期 & "# and 原料仓库ID=" & [原料仓库ID] ) AS 库存
FROM qry原料库存联合
GROUP BY qry原料库存联合.代码ID, qry原料库存联合.原料仓库ID, qry原料库存联合.日期
ORDER BY qry原料库存联合.原料仓库ID, qry原料库存联合.日期;