Reverse Query?

F

Frosty

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
 
D

Dale Fye

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
 
K

KARL DEWEY

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.
 
Top