OrderBy in a Crosstab Query?

M

monia13

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
 
K

KARL DEWEY

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");
 
Top