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.
 
You must log in or register to reply here.

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

Partial match Join query 3
Ranking Mtk Volume 4
Simple Query Not Producing Certain Records... 4
iIF clause 4
Join query 3
Simple Access Query using VBA 1
Inner join with some null values 5
The lowest of all? 6

Back
Top