Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2008
    Posts
    20

    Unanswered: renaming columns of a crosstab query possible??

    can i rename columns of a crosstab query??

    can u explain using this example..



    Code:
    TRANSFORM Sum(foJUN.OPEN_INT) AS SumOfOPEN_INT
    
    SELECT foJUN.SYMBOL
    
    FROM foJUN
    
    WHERE (((foJUN.STRIKE_PR)=0) AND ((foJUN.OPTION_TYP)="XX") AND ((foJUN.TIMESTAMP)=Date()-1) AND ((foJUN.INSTRUMENT)="FUTSTK"))
    
    GROUP BY foJUN.SYMBOL
    
    PIVOT foJUN.EXPIRY_DT;

  2. #2
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    Well since a crosstab uses DATA to generate its column names, you can just change the data.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  3. #3
    Join Date
    Feb 2004
    Location
    One Flump in One Place
    Posts
    14,912
    ....or you can use expressions if there is an algorithm.
    If it is simply "x" becomes "y", "a" becomes "b" then I would add a field to your table and put these values in there.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •