Row heading sort in Crosstab query

[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?

 

[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.

 

[Opal]

Thank you, Karl, that did it!