Cross tab month/year headers not in the correct order

[Singlespeed]

I have 12 months worth of appointments and need to show totals per month so I make month/year with datepart "m" & "yyyy" but the months dont come in the right order on the cross tab.

Has anyone got a trick to resolve this please?

 

[jjturner]

Have you tried: Format([myDateField],"yyyy-mm")