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!!!)
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.
March 1st, 2003, 11:23 PM
no good - that's the PIVOT section