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

Setting column width in a table with a macro is not working 0
Create a chart from a table in word thats dynamic 0
Creating a Search using a combo box and then creating a report. 4
Trying to create a report that will list unmatched records by Ticket Primary Key 0
Sorting Multiple Tables 1
Dates In Excel 5
Export BPMN Visio Chart to Excel 0
"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0

Top