这一天的这种物品只有进货没有出货,没有记录所以导致出错
修改了一下加入NZ(表达式,0)函数处理后
基于qry的日库存:
SELECT qry.date, qry.id, nz(Sum(nz([inqty])),0) AS in_qty, nz(Sum(nz([outqty])),0) AS out_qty, nz(DSum("inqty","tblIn","date<=#" & Format([date],"yyyy-mm-dd") & "# and ID='" & [id] & "'")-DSum("outqty","tblout","date<=#" & Format([date],"yyyy-mm-dd") & "# and ID='" & [id] & "'"),0) AS Remain
FROM qry
GROUP BY qry.date, qry.id
ORDER BY qry.date;
可以正常显示了
这一天的这种物品只有出货没有进货,导致计算出错
修改了一下加入NZ(表达式,0)函数处理后
基于qry的日库存:
SELECT qry.date, qry.id, nz(Sum(nz([inqty])),0) AS in_qty, nz(Sum(nz([outqty])),0) AS out_qty, nz(DSum("inqty","tblIn","date<=#" & Format([date],"yyyy-mm-dd") & "# and ID='" & [id] & "'")-DSum("outqty","tblout","date<=#" & Format([date],"yyyy-mm-dd") & "# and ID='" & [id] & "'"),0) AS Remain
FROM qry
GROUP BY qry.date, qry.id
ORDER BY qry.date;
可以正常显示了
总记录:2篇 页次:1/1 9 1 :