Results 1 to 2 of 2

Thread: Crosstab Query

  1. #1
    Join Date
    Apr 2002
    Posts
    3

    Unanswered: Crosstab Query

    Is there anyway to create a crosstab query where you can specify more than one column field? For example, I would like to see results grouped by group type (total of 3 groups) and then answer type (y, n, na) for the columns, and then heading and question as the rows, with the count of the answers as the values. So far it seems like the developers of Access could never foresee the need for multiple column selections? Any help is greatly appreciated. TIA.

  2. #2
    Join Date
    Sep 2003
    Location
    New York
    Posts
    3

    Re: Crosstab Query

    I was recommended to create several crosstabs queries, and then join them with a union query. I'm not sure if there's a way to code it in one query or not.

    Havana

    Originally posted by mackermj
    Is there anyway to create a crosstab query where you can specify more than one column field? For example, I would like to see results grouped by group type (total of 3 groups) and then answer type (y, n, na) for the columns, and then heading and question as the rows, with the count of the answers as the values. So far it seems like the developers of Access could never foresee the need for multiple column selections? Any help is greatly appreciated. TIA.

Posting Permissions

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