How do I run a stock query

[Guest]

I want to run a stock query from the following. Products table - ProductID
and Title fields, Sold Stock - ProductID and Quantity fields, Bought Stock -
ProductID and Quantity fields. As Bought Stock has enteries that are not in
Sold Stock I don't know how to make them appear.

Please Help

 

[Allen Browne]

Typically this involves:
- a known starting quantity (from the last stocktake),
- plus sum of your purchases since then,
- less sum of your sales since then.

For basic suggestions on how to set this up and perform the cacluation, see:
Inventory Control - Quantity On Hand
at:
http://members.iinet.net.au/~allenbrowne/AppInventory.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

message
news:[email protected]...