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

  • Thread starter Thread starter Heather
  • Start date Start date
H

Heather

How do I find all the records that are in one table but do not have matches
in another table
 
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.
 
Back
Top