Comparing Names In 2 Lists To Find Missing Ones

[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

 

[Michel Walsh]

Hi,

You can run the query wizard about finding unmatched records?

Hoping it may help,
Vanderghast, Access MVP