|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
Stop making mediocre tutorials.The best tutorials are video! Camtasia Studio makes it easy to create engaging, buzz-building screen videos at any size, in any popular format. Download the free trial!
|
|
#1
February 26th, 2003, 03:15 AM
|
||||
|
||||
|
Access crosstab query column headers
I'm trying to modify an Access crosstab query's headers but can't make them behave the way I want:
There are 2 headers that come from the SELECT bit - the first (Group by field) and the last (the Sumed field). The rest of the column headers are in the Pivot section, but when I try to add a new header (that should go before the last Sumed one) it is added in the end! More so - it doesn't matter what order the column headers appear in the pivot section, they always appear in the same order when I run the query which is the order before I added the new header! Help would be appreciated (since I'm going mental!!!)
|
|
#2
February 27th, 2003, 02:50 PM
|
|||
|
|||
|
In the query properties sheet, there is a Column Headings box. You may type the headings you want, separated by semicolins or otherwise enclosed in quotes and separated by commas.
Russ
|
|
| Viewing: Dev Shed Forums > Databases > Database Management > Access crosstab query column headers |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
