Results 1 to 2 of 2

Thread: Transform query

  1. #1
    Join Date
    Mar 2004
    Location
    Slovenia
    Posts
    56

    Unanswered: Transform query

    nu type amper
    1 cr50 400A
    2 cm27 500A
    3 cm3 600A

    this is the result of my query!

    now, I would like to have in following form:

    nu 1 2 3
    type cr50 cm27 cm3
    amper 400A 500A 600A


    I tried with crosstab but it didn't work...

    thx
    Back to the basics...

  2. #2
    Join Date
    Oct 2003
    Location
    Canada
    Posts
    574
    crosstab queries could only handle 1 column to switch. I had a similar problem where the user needed both average times and a count of incidents for a given set of years in a crosstab-like format. I had to build it manually and put it into a table to feed the report. You can do the same if you have a set limit to the number of nu records. I imposed a limit to the number of years that the user could select. I determined that limit by the number of years that would fit on the landscape report.

    You can do:

    nu 1 2 3
    type cr50 cm27 cm3

    or

    nu 1 2 3
    amper 400A 500A 600A

    but

    nu 1 2 3
    type cr50 cm27 cm3
    amper 400A 500A 600A

    will require extra work.

Posting Permissions

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