Row heading sort in Crosstab query

  • Thread starter Thread starter Opal
  • Start date Start date
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?
 
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.
 
Back
Top