L
LindaC
I am not sure where to put this subquery? Thanks.
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.
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.