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

N

Needing HELP

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?
 
O

Ofer

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