Multiple X Bar Names

R

Ripper

The graph, although simple to develop, is giving me problems creating.

Each school has 5 categories of students (1-5). I used a crosstab query
below:
TRANSFORM Avg(qryPercents.[ELA-MS]) AS [AvgOfELA-MS]
SELECT qryPercents.ET, Avg(qryPercents.[ELA-MS]) AS [Total Avg]
FROM qryPercents
GROUP BY qryPercents.ET
PIVOT qryPercents.CampusNum;

I takes the school number as a row heading then uses the ET number as a
column heading and then the Average % Correct as the value. There is also a
Total Avg Column for each school.

The final graph needs to have the Campus and ET number along the X axis and
the Avg % correct going up the Y axis.
]
]
] [Average Percent Correct Here]
]____________________________
ET 1 2 3 4 5 1 2 3 4 5 1 2 3 4 5
Campus 101 103 107

How on earth, but more specifically in Access, do I do that?
 
D

Duane Hookom

I think you need a query like:
TRANSFORM Avg(qryPercents.[ELA-MS]) AS [AvgOfELA-MS]
SELECT "All" as RowHead, Avg(qryPercents.[ELA-MS]) AS [Total Avg]
FROM qryPercents
GROUP BY "All"
PIVOT qryPercents.CampusNum & "-" & qryPercents.ET;

If that doesn't work, I would create a basic report based on a query and use
a little code with Me.MoveLayout = False to create a chart.
 
Top