exclude records

[slimjen1]

All, I am using 2010 Access I have a query that returns what I need. But now I want to exclude records that are in another table. How do I exclude all records that are in another table. My first thought was to use the where clause but I want all the records to be excluded in the table.
thanks

 

[plog]

You LEFT JOIN that other table (show all from original table), then you bring down the primary key from that new table and put 'IS NULL' in its criteria.

 

[slimjen1]

Thanks so much. I couldn't think of this