Need correct order for month names in cross tab

[Bill]

Hi All,

I need the columns of a cross tab query to be headed by the month name but
ordered correctly from left to right.

Any pointers on how to do this please?

Regards.
Bill.

 

[John Vinson]

Hi All,

I need the columns of a cross tab query to be headed by the month name but
ordered correctly from left to right.

Any pointers on how to do this please?

Regards.
Bill.

Set the query's Header property to

"Jan","Feb","Mar","Apr","May","Jun","Jul","Aug","Sep","Oct","Nov","Dec"

or to the full month name if that's what you're using.

John W. Vinson[MVP]

 

[Guest]

Open your query in the SQL view and edit last line based on your months - JAN
or January.
PIVOT xxxxx;
to read
PIVOT xxxxx IN("JAN", "FEB", "MAR", "APR" ...... , "NOV",
"DEC");

 

[Bill]

Thanks both.
Bill.