bruceblack
Registered User.
- Local time
- Today, 14:46
- Joined
- Jun 30, 2017
- Messages
- 119
Hello everybody! I have a somewhat complex problem i have been working on, but unfortunately my brain is too limited for this to comprehend and fix. Please help! (ill try an be as specific and simple as i can, bare with me)
I work in a warehouse where we have to do cyclecounts (count stock and compare with whats in the system). So i build a database that has 2 tables:
- Warehouse_Stock
- Scanned_Products
In both tables we have the following fields:
- Location
- Item
- Serial number
- Quantity
I have a query from the warehouse (queryWHS)
I have a query from the scanned products (queryPRODUCTS)
So i scan the products and at the end i need query that shows me if there are any differences between the 2 on any combination of the 4 fields.
We can have a product too many, missing, different quantity, wrong serial, wrong item. But how can i compare them? It's impossible to have a unique related field on the scanned products since they are not scanned in a particular order.
I assume i need some SQL, but i have no clue where to start.
I tried unmatched query wizard, but that doesn't return the right results.
Where should we start with this? Please help. Been breaking my head about it. (ps: only not matching records will be sufficient!)
I work in a warehouse where we have to do cyclecounts (count stock and compare with whats in the system). So i build a database that has 2 tables:
- Warehouse_Stock
- Scanned_Products
In both tables we have the following fields:
- Location
- Item
- Serial number
- Quantity
I have a query from the warehouse (queryWHS)
I have a query from the scanned products (queryPRODUCTS)
So i scan the products and at the end i need query that shows me if there are any differences between the 2 on any combination of the 4 fields.
We can have a product too many, missing, different quantity, wrong serial, wrong item. But how can i compare them? It's impossible to have a unique related field on the scanned products since they are not scanned in a particular order.
I assume i need some SQL, but i have no clue where to start.
I tried unmatched query wizard, but that doesn't return the right results.
Where should we start with this? Please help. Been breaking my head about it. (ps: only not matching records will be sufficient!)