Find unmatched qry, using two fields?

[ironj32]

Is there a way to do a Find Unmatched Query, based on two fields? When using the wizard it gives the option for only one field.

I have two tables each with a Name and Site field.
I want to see if there are any discrepincies between the table based on both fields. I need to find out what records are missing from Table2. i.e. Table1 could have
Name Site
John 1074
Jim 1074
John 1012

and Table2 will have
Name Site
Sue 1074
Jim 1074
John 1012

I need to know if John 1074 is missing in Table2. Is this possible? I'm hoping the answer is yes, because each table contains over 10,000 records.

Thanks for your input!

[ironj32]

I'm thinking that if I set Relationship between the two tables using the Site as the joined fields. Then do an unmatched query using the Name, that it might work?

[asingh]

Hi,

Create a concatenate field via a query between name and site. For both tables..then use the UNMATCHED query wizard to differentiate....!!!!!