Non Matches

P

Patrick M

Thank you for your help.
I have two lists and want to know the records that do not match. For
example which of List 1 names are not also in List 2.

Thanks,
Patrick
 
S

Steve

See my response to your previous post. Base a second query on the new query
and List 2. Pull down FullName from the new query and Full Name from List 2
into the query grid. Put the following expression in the criteria of Full
Name:
Not FullName.

Steve
[email protected]
 
Top