Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Dec 2000
    Location
    Temple, Texas, USA
    Posts
    94
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Totals in Crosstab Query (2000 SR-1)

    Hi. I am new to this forum; I usually hang out in Excel. I have a large (>100,000 records) table I'm trying to do what in Excel would be a pivot table. I'm counting three different types of prescriptions and which pharmacist did them. I used a Crosstab query and I can get the counts for each type and pharmacist, but not the totals. How can I get the totals in Access? I've attached a sample Excel sheet to demonstrate; I hope it's clear. Thanks for any and all suggestions!
    Attached Files Attached Files
    Jim Whitt
    Pharmacist
    Temple, Texas

  2. #2
    Star Lounger
    Join Date
    Sep 2001
    Location
    SC, USA
    Posts
    60
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Totals in Crosstab Query (2000 SR-1)

    Use the query wizard to create a second query that uses your crosstab as input. Place all fields from the crosstab into the new query. Now, add a field that simply combines the three count fields.
    Totals: [CountfieldA]+[CountfieldB]+[CountfieldC]
    Let this new query be the basis for your report or form instead of your crosstab query. <img src=/S/chatter.gif border=0 alt=chatter width=38 height=16>

  3. #3
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Totals in Crosstab Query (2000 SR-1)

    If you use the wizard to construct your crosstab, there is an option to add totals to the crosstab.
    Wendell

Posting Permissions

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