I have two tables and need to cross-check my data and show records that DO NOT match from BOTH sources. How do I go about doing this?
There is a common ID for the records.
Thanks!
I have two tables and need to cross-check my data and show records that DO NOT match from BOTH sources. How do I go about doing this?
There is a common ID for the records.
Thanks!
Have you looked at the UnMatched query wizard?
Yes but I need records from BOTH sources.
So it is two queries. Is that a problem?
The problem is I need to show ALL records that do NOT match from both sources.
Say this is my data from
Table 1
ID: 12345
Name: Penny Marshall
Division: Atlanta
District: 1
ID: 23451
Name: John Travolta
Division: Florida
District: 2
Table 2:
ID: 12345
Name: Penny Marshall
Division: Atlanta
District: 1
ID: 234512
Name: Rick Shroeder
Division: Alabama
District: 3
I need a table/query that would show John Travolta and Rick Shroeder but not Penny Marshall
Two Unmatched queries put together in a UNION query.
Thank you!
You're welcome. Are you ready to use the Solved thread tool yet?