Hi Folks
This has got me stumped. I trying to build a query that will show me stores (Str) who have not sold items but that them on Hand (OH) to and match them to stores who have sold items and have none on hand. A kind of supply and demand. The table has 12 different stores and each store has the same items. So there are duplicates items and duplicate stores. So I have tried showing data to show stores that has not sold an item and have it OH and tried to join with Stores that have sold items do not have it on hand. When I link the items of both querys and I have tried Make tabel querys is does bring back the correct data.
Hope this make sense to you. Thank you for your help.
Qry Sold and OH (Ratio)
StrItem#O/HSOLDExpr1primary KeyFTU4053310-11SAN4414310-12SAN441450113SAN441530004