Unmatched query multiple criteria

[Tlou5831]

I am attempting to compare 2 tables in my DB and find unmatched criteria.

There are 2 different fields in each database that need to be compared.

Tbl_AppUsers

Role Settings
INQ INQS
INQ INQSO
BASIC BALQU
BASIC ENTRY

Tbl_RoleSetting s

Role Settings
INQ INQS
INQ INQSO
BASIC BALQU
BASIC ENTRY

I would like to perform a query that the fields that basically says If TBL_APPUsers.Ro le + TBLAPPUsers.Set tings <> TBL_RoleSetting s.Role + TBL_.Settings show in the results in the query.

I attempted to do this in the unmatched query wizard but you are only able to compare 1 field.

Thanks for the help.

[cori25]

Create a query and bring in both tables.

Create a join for Role to Role and Settings to Settings as number 2(the joined fields have to be equal)

Pull in all the fields from one of the tables, for fields Role and Settings put "Is Null" in the criteria and run

Let me know if this works