#1
  1. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2002
    Posts
    123
    Rep Power
    13

    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. #2
  3. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Feb 2003
    Location
    Rogers, AR
    Posts
    5
    Rep Power
    0
    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
  4. #3
  5. Contributing User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2002
    Posts
    123
    Rep Power
    13
    no good - that's the PIVOT section

IMN logo majestic logo threadwatch logo seochat tools logo