I've been working with Access for several months now and have run into an issue that I'm unsure how to fix. I Currently have a query with the following Data. The Scores Below represent different parts of a phone call that make up an entire score
Supervisor CSR Monitor Score1 Score2 Score 3
Stephanie Mike Jenny 10 5 10
Stephanie Mike Michael 10 5 5
Stephanie Mike Michael 10 10 5
Stephanie Tom Jenny 10 10 10
Stephanie Tom Karen 10 10 10
Stephanie Steve Jenny 10 10 10
Michelle George Karen 10 5 5
I currently have a report that gives the Average scores for the CSRs working under a specific Manager. It Gives the following breakdown.
Report Header
Manager
Score1 Average; Score2 Average; Score3 Average
Details
CSR
Score1 Average; Score2 Average; Score3 Average
I'm trying to get a detailed report that further breaks down this information.
Report Header
Manager
Score1 Average; Score2 Average; Score3 Average
Details
CSR
Score1 Average; Score2 Average; Score3 Average
Monitor (As scored to an individual CSR)
Score1 Average; Score2 Average; Score3 Average
Monitor (As scored to an individual CSR)
Score1 Average; Score2 Average; Score3 Average