How to compare 2 lists to see which accounts are double in Access

G

Guest

I need to compare two lists each containing account numbers on it. One list
contains numbers from the previous day, the second list contains a whole list
of account numbers. I need to compare both lists to see how many accounts
from the previous day DO NOT appear on the second list, or how many doubles
we have?
 
G

Guest

By list, I assume you are talking about two queries.
I that case you can use the query wizard to create an unmatch records, that
apear in one query/table and not in the other one.
 

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

Comparing two lists 3
Compare two lists 1
how to compare list 2
How to setup database to make transactions (transfers) between two bank accounts 0
XL2000 CF and Comparing Lists 5
How do I match two large files to find matching telephone numbers 2
Comparing Lists 1
compare pairs of columns 3

Top