Hi everyone,
Still making inroads on my DB and have now come against my next problem.
I have 2 tables and 2 queries in this quesiton:
I think this would be an unmatched query, but I can't work out how to do it. The resulting query that I get just shows either the warehouse locations that don't appear in qryInventory OR locations not in qryZeroStock... but not both.
Is it possible to compare 2 queries against a table and display the unmatched items?
thanks as always,
Chris
Still making inroads on my DB and have now come against my next problem.
I have 2 tables and 2 queries in this quesiton:
- tblWarehouseLocations - this is the master list of all storage locations in the warehouse
- tblInventory - this is a list of all items that have been put into our warehouse, the storage location and the current quantity
- qryZeroStock - this query displays all storage locations for a given PartId on the form that have zero as a stock level (this represents "previous" storage locations for that part
- qryInventory - this displays all locations for the given PartID that have a stock value of more than zero in the inventory table
I think this would be an unmatched query, but I can't work out how to do it. The resulting query that I get just shows either the warehouse locations that don't appear in qryInventory OR locations not in qryZeroStock... but not both.
Is it possible to compare 2 queries against a table and display the unmatched items?
thanks as always,
Chris