Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jun 2005
    Location
    Atlanta, Georgia, USA
    Posts
    208
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Crosstab queries with multiple values (2003)

    I have a query that has week of , unit cost, claims, and Paid amount and Category(5 to 10k,10 to 20K,and >20k). From this query, I want to create a report that has week of going down the left side and category going across the top with corresponding unit cost, claims, and paid amt under each respective category. In a crosstab query I can only pick 1 value but I need 3. How can I get around this?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Crosstab queries with multiple values (2003)

    Create three crosstab queries: one for unit cost, one for claims, and one for paid amount.
    Then create a query based on the three crosstab queries, joined on the week field to return all the values.
    Use this query as record source for the report.

  3. #3
    2 Star Lounger
    Join Date
    Jun 2005
    Location
    Atlanta, Georgia, USA
    Posts
    208
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Crosstab queries with multiple values (2003)

    thanks Hans that works.

Posting Permissions

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