Results 1 to 2 of 2

Thread: Crosstab Query

  1. #1
    Join Date
    Apr 2002
    Posts
    168

    Unanswered: Crosstab Query

    I have a table like this :

    ID Score_1 Score_2

    001 5 8
    002 3 4


    Is it possible to create a crosstab query so my table becomes :

    001 002

    Score_1 5 3
    Score_2 8 4

    I need the above table structure so I can create a report that looks like that.


    Thanks.

  2. #2
    Join Date
    Jun 2002
    Location
    Central New Jersey
    Posts
    69

    Re: Crosstab Query

    With crosstab you need at least 1 column, 1 row and 1 value. You only have 2 fields, so I don't believe that crosstab will work for you.

    Sorry I couldn't be more helpful.
    "There's never enough time to do it right, but there's always enough time to do it over!"

Posting Permissions

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