Need help with Unmatched Query!

[e_lady]

I created an unmatched query with the wizard and it works fine - when I want to compare with only one field. Is there anyway possible for it to compare two fields? I need for it to look at field1 and field2 when checking for unmatched records. Any ideas?

 

[ByteMyzer]

The following sample query will return records in Table1 which does not have corresponding values in Table2 for fields Field1 and Field2:

SELECT Table1.*
FROM Table1 LEFT JOIN Table2 ON Table1.Field1=Table2.Field1 AND Table1.Field2=Table2.Field2
WHERE Table2.Field1 Is Null;

 

[e_lady]

Thanks - it worked perfectly!!!