OrderBy in a Crosstab Query?

[Guest]

I want to sort months in a cross tab query so they appear in the right order
vs alpha numeric.. Can I use OrderBy command? If yes, where do I input that
commend

 

[Guest]

This gives month-year order, maybe it will help.

TRANSFORM Count(EventSched.X) AS CountOfX
SELECT EventSched.Event, Count(EventSched.X) AS [Total Of X]
FROM EventSched
GROUP BY EventSched.Event
PIVOT Format([Appointment],"mmyyyy") & " " & Format([Appointment],"mmm -
yyyy");