query for differences

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This seems like a simple question, but I just don't know the syntax. I have
two tables with ID numbers. The lists are almost the same, but there may be
a few ID's in one table and not the other. What is the query expression
syntax to get a list of the ID numbers that appear in only one of the tables?
 
Go to the query tab.

Click New.

Select "Find Unmatched Query Wizard".

Rick B


Amy said:
This seems like a simple question, but I just don't know the syntax. I have
two tables with ID numbers. The lists are almost the same, but there may be
a few ID's in one table and not the other. What is the query expression
syntax to get a list of the ID numbers that appear in only one of the
tables?
 
Back
Top