Results 1 to 3 of 3
  1. #1
    Join Date
    May 2014
    Posts
    98

    Unanswered: Crosstab query to have 2 column headings

    I have one more question. How do I join two crosstab queries so that I have 2 column rows.
    So for example, I want all people name in row heading of crosstab query and courses they need to learn in column heading and another column heading which is type of course.
    Course A Course B Course C
    Type A Type B Type C
    Joe
    John
    Jessica

    I have to also set the criteria as "dept" person belong to.

  2. #2
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    495
    Provided Answers: 24
    you cant do that.
    You either get :
    Courses, a,b,c
    or
    types: a,b,c
    not both.

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    I guess if you made a composite of coyrse and type BEFORE doing the pivot it may work, then reformat in the data consumer form or report so you get the dinky headings you orobably want
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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