Crosstab column order

[Dan Sully]

Is there any way to control the column order in the results of a crosstab
query?

Suppose the column names are in date format?

I am trying to do a crosstab to generate series for an excel chart which
needs to be in rows rather than columns--hence the crosstab.

Thanks.

 

[Duane Hookom]

Columns are created in alphabetical order unless you specify the columns in
the Column Headings property of the Crosstab.