Non Match queries

[LAURA HAUG]

I am trying to match two files to find any members that are not duplicates, however, I need to use two fields in order to ensure that they are duplicates. I have been trying to utilize the unmatch query and it appears to allow only one field to be checked. Is there a way to do this. Currently, I have to export the files into Excel and write If-Then statements and the import them back into the database. Any Help!!!

 

[Dugantrain]

This is what I generally do for this problem:
Write two separate queries each based off of one of the tables. Add a field to each query and concatenate (big word, it just means "squish together") the two fields that you're trying to find Dupes for. You do this by:

Name_Of_Your_New_Field:[Field1]&[Field2]

Of course, replacing the generic code above with the field names and what you want this new field to be called. Do the exact same thing in the query based off of the 2nd table. Now you can use the Unmatched Query wizard and match these two queries up by the concatenated fields!