tahirih
asked on
Access - 3 table query
Hi,
In the attached spreadsheet, the first tab lists a diagram of three tables. Tables A (Green) and B (Blue). Table C was created by an inner join on Tables A and B, on the fields Car, NBR1, and NBR2.
Now, based on Table C that was created from A and B, I am creating a three table query with C, D, and, E, with the intended output to deliver Table Z that has the rows highlighted in pink (where the Code, ID in Tables D and E are not the same).
Tables C, D, and E will be joined on Car, NBR1, and NBR2 as well. Due to the nature of the source data, the processing had to happen in this method, and cannot be changed.
Thank you
Match-Unmatched.xlsx
In the attached spreadsheet, the first tab lists a diagram of three tables. Tables A (Green) and B (Blue). Table C was created by an inner join on Tables A and B, on the fields Car, NBR1, and NBR2.
Now, based on Table C that was created from A and B, I am creating a three table query with C, D, and, E, with the intended output to deliver Table Z that has the rows highlighted in pink (where the Code, ID in Tables D and E are not the same).
Tables C, D, and E will be joined on Car, NBR1, and NBR2 as well. Due to the nature of the source data, the processing had to happen in this method, and cannot be changed.
Thank you
Match-Unmatched.xlsx
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I may have figured this out - yes, this is hard to describe without actual data. Sorry.
What is your question?
Regards,
Bill