Microsoft Access Question

For the purposes of explaining a potential answer in this thread this is what I did on my database reconstruction...

• I created three tables tblGEOCodes, tblStoreMasterOLD and tblBODates.  The table tblGEOCodes are where each location/category are stored for subsequent assigning in other tables.  As each category in this table is unique I simply created one field as the primary key.
• One to many relationships were formed from the tblGEOCodes listing/table to the appropriately linked fields in tblStoreMasterOLD and tblBODates.
• Created a query called qryBODateStores which showed all stores which correspond to the BO Date entered in the query itself.
• Created an unmatched query (using the Access Query Wizard) to show all store details from tblStoreMasterOLD which haven't appeared in the query above, therefore providing you with the answer specifically for the date in question entered in qryBODateStores.

I've attached a relationship diagram showing the structure.  Notice I've checked the "Enforce Referential Integrity" box when setting the one-to-many relationships as one location/category (GEO Code) can appear multiple times in both corresponding tables.

I tried to attach my database but it isn't being allowed, happy to WeTransfer to you if desired, drop me a private message with your email address if so 🙂

I look forward to seeing if this has resolved your issue or any further feedback you wish to provide.

Chris