yoducati
asked on
Access Crosstab Query with Multiple Values
I am trying to help a coworker solve a query issue. He has two existing crosstab queries that we'd like to combine into one.
The first table identifies all "possible" audit issues by quarter for a specific office, and the second identifies those that we have marked as legitimate findings.
We are trying to breakout the findings of both queries into one crosstab like in the attached file.
Crosstab.xlsx
The first table identifies all "possible" audit issues by quarter for a specific office, and the second identifies those that we have marked as legitimate findings.
We are trying to breakout the findings of both queries into one crosstab like in the attached file.
Crosstab.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
Thanks for the help! I think we were close to getting it but something just wasnt working. The left join and syntax was the issue. Works great now!
Glad I could help.
so upload a copy of a db with the table