CrossTab Query Date Conversion

[Evagrius]

Hello,

I have a crosstab query with a column heading of the name of the month. The proble is that when I run the query, the months are not sorted according to their natural progression. Of couse sorting asceding and descending will not work. I would appreciate any ideas. Thank You!

 

[vbaInet]

You would have to have Static pivot headers:

PIVOT MonthField In ("January", "February", ... and so on)

 

[Evagrius]

Thank You.

 

[vbaInet]

No problem!