A
Annoyed of Access
I want produce a query that does a very simple stock report. I have tried to
follow Allen Browne's Stock in Hand but I think it is too complicated for
what I need.
What I have are 3 tables - Products, Sold & Bought. Products Primary Key =
ProductID. Sold & Bought both have ProductID in.
I want to sum the quantity bought of all ProductID and then subtract from
the sum of the quantity sold of all ProductID.
Part of the data is as follows:
ProductID QtyBought QtySold QtyBought-Sold
5575 1 1 0
5575 4 1 3
If I use the Sum function in the total Field the result is as follows:
ProductID QtyBought QtySold QtyBought-Sold
5575 25 10 15
Please can somebody help out??!!
follow Allen Browne's Stock in Hand but I think it is too complicated for
what I need.
What I have are 3 tables - Products, Sold & Bought. Products Primary Key =
ProductID. Sold & Bought both have ProductID in.
I want to sum the quantity bought of all ProductID and then subtract from
the sum of the quantity sold of all ProductID.
Part of the data is as follows:
ProductID QtyBought QtySold QtyBought-Sold
5575 1 1 0
5575 4 1 3
If I use the Sum function in the total Field the result is as follows:
ProductID QtyBought QtySold QtyBought-Sold
5575 25 10 15
Please can somebody help out??!!