By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,299 Members | 1,071 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,299 IT Pros & Developers. It's quick & easy.

Unmatched query multiple criteria

P: 8
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_RoleSettings

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.Role + TBLAPPUsers.Settings <> TBL_RoleSettings.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.
Feb 15 '08 #1
Share this Question
Share on Google+
1 Reply


cori25
P: 83
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
Feb 15 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.