I have a crosstab query called Enrolled crosstab. ABE, GED, Conflict represent a column in the crosstab query. I want to be able to select the column with a drop down list
Enrolled crosstab
ABE
GED
Conflict
Field ID ABE Table Enrolled crosstab Sort Show Criteria is null
What I can't figure out how to do is change the red field to ABE, GED, Conflict
Here is the Crosstab query
Enrolled
ID
Mod
Enroll type
TRANSFORM First(enrolled.[Enroll Type]) AS [FirstOfEnroll Type]
SELECT enrolled.ID
FROM enrolled
GROUP BY enrolled.ID
PIVOT enrolled.[Mod];
FIELD ID MOD ENROLL TYPE TABLE ENROLLED ENROLLED ENROLLED TOTAL GROUP BY GROUP BY FIRST CROSSTAB ROW HEADING COLUMN HEADING VALUE
The result is