Basic Access Question - Excluding data found in table

[Quietuss]

Hello everyone,

I am new to access, and am learning bit by bit.
I am building a query with a column of data, 'location number'.
I need to exclude any data where the location number is found in a pre-built table.

i.e. return all data except when the location number is found in the table.

Thanks.



Quieutss

[pbaldy]

Try the unmatched query wizard.

[Quietuss]

Thanks a bunch!

[pbaldy]

No problem, and welcome to the site!