Skip to content
Advertisement

Data exclusions based on two-tables MS Access

I have table A which includes all data based on a read date. For example:

From that data set, I created a query that looks at a list of off-peak holidays, as well as off peak days, and created a table from that. This table looks like:

I need to create a query that will give me table A data EXCLUDING table B data. Which would look something like this:

I have tried different join, NOT IN, WHERE NOT, and many others, which would sadly just return all results from Table A or no results at all.

PS – I apologize for the formatting, new to all of this.

NOT IN, WHERE NOT, <>, LEFT JOIN, ISNULL

Advertisement

Answer

Use not exists:

User contributions licensed under: CC BY-SA
6 People found this is helpful
Advertisement