Need correct order for month names in cross tab

  • Thread starter Thread starter Bill
  • Start date Start date
B

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.
 
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.
Click to expand...

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