Reverse Query?

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

Guest

I have two lists one with 200 names and another with 205 names. What can i
do to find out the 5 names that don't match. I have access 2000
 
Can you tell us your table structure?

Are the names in the same field? If so, you might want to try creating an
Unmatched query using the query wizard. If the names are split into 2 or
more fields, it becomes a little more complicated, but not much.

Dale
 
Use the two queries in a third and left join the 205 to the 200. Use Is Null
criteria on joined field of the 200.
 
Back
Top