Query complement?

[miguelito_cz]

I have a database of basically two tables - tblBoxes and tblFilesInBox. Each box has got 250 slots to store files. In tblFilesInBox, I keep the records of files that are stored in the boxes, including their position (slot) in the box. If the slot is free, there is no information stored about it.

I want to somehow get the list of free slots for a given box. I was thinking that maybe unmatched query would do the job, but I can't make it work. Does anyone have any idea?

 

[Trevor G]

What about creating a query against both tables then in the criteria place in Is Null if there is no data it should return a list of empty records.

If I haven't followed the question right perhaps upload a sample of your database (take a copy first) so someone can take a look at it.

 

[miguelito_cz]

What about creating a query against both tables then in the criteria place in Is Null if there is no data it should return a list of empty records.

If I haven't followed the question right perhaps upload a sample of your database (take a copy first) so someone can take a look at it.

Thanks for your reply Trevor. I decided for a VBA approach which works just fine. Thanks anyway!