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
(e-mail address removed)
 

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

Insert name and adress from a list in a word document 1
Drop down lists in seperate columns 5
Weekly Report 2
How to make repeating drop-down lists? 2
Finding the right style field in VBA 0
Word- Find and Replace 1
Need help modifying code 0
Duplicate hashtags in OneNote 0

Top