I have this query which shows the correct results
If I add a >0 as a criteria to Stock column above, the query asks for two parameters (InSum & OutSum).
The query without criteria for Stock :
Any kind of help is appreciated.
SQL:
SELECT
d.PartID,
Sum(d.Quan_In) AS InSum,
Sum(d.Quan_Out) AS OutSum,
[InSum]-Nz([OutSum]) AS Stock,
[TraceCode] & "" AS TraceC
FROM
tblOldData AS d
GROUP BY
d.PartID, [TraceCode] & ""
ORDER BY
d.PartID;
If I add a >0 as a criteria to Stock column above, the query asks for two parameters (InSum & OutSum).
The query without criteria for Stock :
Any kind of help is appreciated.
Attachments
Last edited: