End result is i need a report created from the following Acess Data.
Each User Should display every available channel.(From Channel table,
Even if the user has no values display a zero)
In House
SBB
TDRM
TDRS
Should have a report for all agents in agent table
HOLTBA2
LIMC6
KOUMAJ2
KAURK3
BALARL2
TRINHL2
HEMMIM3
BATTAS2
MESTRS2
I have an example of what i need done, attached as a picture, if its possible to do it from one table that gets populated that would be great, If sub reports are required. then it would be beset to have custome tables created. And i would need the following fields or something similar
## Deliverables
Person 1
Channel GOAL Count Time
In House In house goal inhouse count Inhousetime
SBB SBB Goal SBB Count sbbtime
TDRM TDRM TDRM count TDRM time
TDRS TDRS Goal TDRS count TDRS time
Section2
Person 1
Channel GOAL Count Time
In House In house goal inhouse count Inhousetime
SBB SBB Goal SBB Count sbbtime
TDRM TDRM TDRM count TDRM time
TDRS TDRS Goal TDRS count TDRS time
Section 3
Person 1
Managers Discretion Percentage
Email Percentage
System ERror Percentage
end result as well, i want to populate it for a year to date table, so ideally if thsi is all doable from one local table, with weird normalization im ok with that.