Results 1 to 2 of 2
  1. #1
    5 Star Lounger
    Join Date
    Nov 2004
    Location
    Wilmington, North Carolina, USA
    Posts
    1,196
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Crosstab Query Total ROW? (Access 2000)

    Is it possible to create a query row? I have a query that would look similar to this:

    COMPANY..........PRODUCT......TYPE 1.....TYPE 2....TOTAL
    A......................WIDGET..........3.......... ......1...............4
    A......................GEAR...............2....... .........6...............8
    B......................WIDGET..........3.......... ......1...............4
    B......................GEAR...............2....... .........6...............8
    C......................WIDGET..........3.......... ......1...............4
    C......................GEAR...............2....... .........6...............8



    Lately, I've been copy/paste and editing in excel to make it look like:

    COMPANY..........PRODUCT......TYPE 1.....TYPE 2....TOTAL
    A......................WIDGET..........3.......... ......1...............4
    A......................GEAR...............2....... .........6...............8
    TOTAL A.................................5............... .7...............12
    B......................WIDGET..........3.......... ......1...............4
    B......................GEAR...............2....... .........6...............8
    TOTAL B.................................5............... .7...............12
    C......................WIDGET..........3.......... ......1...............4
    C......................GEAR...............2....... .........6...............8
    TOTAL C.................................5............... .7...............12


    Is it possible to do that in a crosstab query?
    ____________________________
    Jeremy
    "If you spend more on coffee than on IT security, then you will be hacked. What's more, you deserve to be hacked." -Richard Clarke

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Crosstab Query Total ROW? (Access 2000)

    No. I an query each row has the same structure, so it can't be done.

    However, You can do it in a report based on a crosstab query. If you Group by company, you could sum values, and put the totals in the group footer.

    Later versions of Access also have pivot tables, which might provide another solution, but they are not in Access 2000.
    Regards
    John



Posting Permissions

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