Unmatched Query

I have created an unmatched query using the wizard.
However I wanted the query to check more than one field
before returning the unmatched records?

Any ideas?

The unmatched query wizard generates an outer join query where the foreign
key is null.

If you want extra fields in the join, you can drag them from one table to
the other. Then double-click the join lines, and choose the option that
gives you the arrow heads pointing in the same direction.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
wrote in message
...

I have created an unmatched query using the wizard.
However I wanted the query to check more than one field
before returning the unmatched records?

Any ideas?