records that are in one table but do not have matches in another t

H

Heather

How do I find all the records that are in one table but do not have matches
in another table
 
J

Jerry Whittle

Assuming that you have a version of Access older than 2007, press the F11 key
to bring up the Database Window.
Next go to the Queries button/tab.
Click on New.
Find Unmatched Query Wizard.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select query returning too many records 2
Query one table against part of a cell of another 3
Excel Highlighting duplicates 0
Match field values and delete record 2
Build a like query based on information contained in another table 1
Quering between 2 large tables involving wildcards 2
Select records based on isolated portion of string 1
Senior moment on capturing all records from joined query 2

Top