Ordering crosstab querey columns

[Greg P via AccessMonster.com]

Hi,

I have a crosstab querey that when I run it, dispays the columns
alphabetically from left to right (the field names are letters W, L, D). Is
there a way I can set the order the columns appear in when the querey is run?

 

[M.L. Sco Scofield]

In the query's design view, open the query property box. The third property
is one you only see for crosstab queries. It is called Column Headings.
Click there and hit <F-1>. Help will tell you all about it.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Denver Area Access Users Group Vice President www.DAAUG.org
MS Colorado Events Administrator www.MSColoradoEvents.com
Useful Metric Conversion #18 of 19: 8 nickels = 2 paradigms (My personal
favorite)
Miscellaneous Access and VB "stuff" at www.ScoBiz.com

Hi,

I have a crosstab querey that when I run it, dispays the columns
alphabetically from left to right (the field names are letters W, L, D). Is
there a way I can set the order the columns appear in when the querey is

run?

 

[Van T. Dinh]

Check Access Help on the ColumnHeadings Property of the Crosstab Query and
see if this can be used in your case.

Remember to read the Note and Remarks in Help carefully.

 

[Dale Fye]

You need to set the column headings in the Query Properties window. Or, you
could just modify the SQL by appending

PIVOT tbl_Ranges.Range In ("L", "W", "D");

to the end of the SQL statement.

HTH
Dale