Row heading sort in Crosstab query

O

Opal

If my row heading in my crosstab is the months
of the year, how do I sort them so they show
in calendar order and not alphabetical order?
 
K

KARL DEWEY

Add like this --
TRANSFORM Count(ExamErrorTracking.[CivilPenalty]) AS CountOfCivilPenalty
SELECT Format([NoticeofHearing],"mmmm") AS Occurence
FROM ExamErrorTracking
GROUP BY Format([NoticeofHearing],"mmmm"), Format([NoticeofHearing],"mm")
ORDER BY Format([NoticeofHearing],"mm")
PIVOT ExamErrorTracking.[LegalDisp];

This adds a second formatted date in the GROUP BY but it is not selected.
It uses it in the ORDER BY but not the displayed format.
 
Top