need help with unmatch query

  • Thread starter Thread starter jng
  • Start date Start date
J

jng

I have two tables both containing first and last names,
which are separated in different fields. I'm trying to
find the people who are on table 1 but not on table 2.
The problem I'm having is when I use the unmatch query
wizard, it'll only allow me to compare one field, for
example last name from table1 to the last name in table2.
This is where I'm having the problems.

On table1 I have:
Mack, Terry
Mack, Sean

On table2 I have only:
Mack, Terry

The result from the query would tell me that there are no
unmatched persons, which is not the result I'm looking
for. Is there a way I can expand the search criteria, so
it'll look at both last and first names?
 
One option would be to create a new compound field
containing both first and last name, for both tables. You
could use queries to do this, so the tables themselves
wouldn't be effected. Then run the Unmatch on that field.
 
Back
Top