trying to get on hand per location

[Russ via AccessMonster.com]

Please help can not figure out best way to achieve the qty on hand and on
backorder.
Not sure how to link and or combine all info...

Have Location Table
LocationID

Have query AllProductsPurchased
LocationID
ProductNumber
QtyPurchased

Have query AllProductsReceived
LocationID
ProductNumber
QtyReceived

Have query AllProductsUsed
LocationID
ProductNumber
QtyUsed

Trying to achieve this type of result and getting way too many records

Location Part OnHand OnBackOrder
1 ABC 32 16
3 ABC 32 0

 

[KARL DEWEY]

You did not say where your queries were getting their information from and
what those queries looked like. Post the query SQL bu opening in design
view, click on VIEW - SQL View, highlight all, copy, and paste in a post.