Link to home
Start Free TrialLog in
Avatar of yoducati
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
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

the source table is required and the explanations about the Total Findings query and the Total legitimate query is important

so upload a copy of a db with the table
ASKER CERTIFIED SOLUTION
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of yoducati
yoducati

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.