Ordering crosstab querey columns

  • Thread starter Thread starter Greg P via AccessMonster.com
  • Start date Start date
G

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?
 
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


Greg P via AccessMonster.com said:
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
Click to expand...
run?
 
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.
 
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
 
Back
Top