L
LindaC
I posted this last week but I am still stuck. I have a location table where
all the records are A1a, A1b, etc and an archive table where the location
field has a relationship with the archive table. This was my original
question and the answer posted below. Not sure where and how to set up the
query with these 2 tables. Thanks.
QUESTION - "We have a warehouse where boxes are located in Aisle A-G, Rows 1
- 10 and
Section a - g. I have records located in, for example G9b. I have other
records already that have locations too. How do I set up a query to find out
where the empty locations are in this grid? Thanks." RESPONSE "I'd create
a table called something like tblAllLocations with the three
fields (Aisle, Rows, Location) or everything in one columm if the data
actually looks like G9b in your table. Then I would populate this table with
every possible location. Next I'd do a Not In or Not Exists subquery to show
the empty locations."
all the records are A1a, A1b, etc and an archive table where the location
field has a relationship with the archive table. This was my original
question and the answer posted below. Not sure where and how to set up the
query with these 2 tables. Thanks.
QUESTION - "We have a warehouse where boxes are located in Aisle A-G, Rows 1
- 10 and
Section a - g. I have records located in, for example G9b. I have other
records already that have locations too. How do I set up a query to find out
where the empty locations are in this grid? Thanks." RESPONSE "I'd create
a table called something like tblAllLocations with the three
fields (Aisle, Rows, Location) or everything in one columm if the data
actually looks like G9b in your table. Then I would populate this table with
every possible location. Next I'd do a Not In or Not Exists subquery to show
the empty locations."