Comparing Names In 2 Lists To Find Missing Ones

  • Thread starter Thread starter David Gibson
  • Start date Start date
D

David Gibson

Hi,

I wonder if anyone can assist with the below problem.

I have two lists of names that I have generated using queries. The
names are in the same style & format in both lists and there are no
duplicates within each unique list. The names are however duplicated
across both lists, ie a name in list A may also be in list B, and in
most cases is in list B

One list is fully comprehensive, ie, it contains all the required
names (approx 6500). The other list is not comprehensive (approx 6000)
and is missing about 500 names when compared to the other list.

Is there a means to identify which names are missing from the smaller
list that are held in the larger list.

Regards
Dave Gibson
 
Hi,

You can run the query wizard about finding unmatched records?

Hoping it may help,
Vanderghast, Access MVP
 
Back
Top