Unmatched qry, 2 fields

Tech-Archive recommends: Speed Up your PC by fixing your registry



Hi:

I have 2 tbls named All HRMS and LOV_tbl. I'm trying to create an unmatched
qry. In each table there are 2 fields I'm comparing. The 2 fields in the
All HRMS are DIRECTORY and LOOKUP_CODE and in the LOV_tbl they are HR Access
directory and Oracle_Lookup_Code. The query should pull where the DIRECTORY
and HR Access directory equal and where LOOKUP_CODE and Oracle_Lookup_Code do
not equal. I can't seem to get it to work using the unmatched wizard.
.