I am building a warehouse management database from the ground up. The problem
I am running into involves the 'location'.

Problem #1- I have an "Upcoming Shipments" table which is just data pasted
from an external spreadsheet e-mailed from clients. I then have a query that
pulls part length from table "Part Numbers" and the 'location' from table
"Receiving". When this query returns its results, it will list all of the
locations the part is in, not just the one I want. Example:

If I need to ship Part Number 1234567, Lot Number A11111 and that is found
in location 5555, it will return that location, but it will also return any
other location that Part Number 1234567 is found, i.e. if Lot Number B99999
is in Receiving, the query will tell me that Part Number 1234567, Lot Number
A11111 is in both 5555 AND Receiving.

Problem #2 is similar - My In-Stock Inventory is basically a query that
subtracts  what we've shipped from what we've received. It normally works
great, but in times where we receive a part with the same part & lot numbers
as one we have on the shelf, it will sum them and say that both locations
have the sum. Example:

We have 5 pcs of part number 1234567, Lot Number A11111 in location 5555. We
receive 7 pcs of the exact same part & lot number. Now my In-Stock Inventory
query says that I have 12 pcs in location 5555 and 12 pcs in receiving.

For reasons I don't want to get into, I can't have a table that just has
part number listed once and a permanent warehouse location (because they
don't have permanent locations). So, I would like to be able to have Access
treat Fields A, B, & C as "locked" together.

Any ideas?