Results 1 to 4 of 4
  1. #1
    Buakaw is offline Absolute novice
    Windows XP Access 2007
    Join Date
    Jan 2011
    Posts
    112

    How to sum values in Crosstab query?


    I would like to sum each column individually in a crosstab query and display the sum at the bottom of each column. The values are in currency format. Is it possible to do this?

    Thanks.

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,715
    This may be useful
    He has a reference to ACC2007
    http://allenbrowne.com/ser-67.html

  3. #3
    Buakaw is offline Absolute novice
    Windows XP Access 2007
    Join Date
    Jan 2011
    Posts
    112
    Thanks orange, will check it out.

  4. #4
    Buakaw is offline Absolute novice
    Windows XP Access 2007
    Join Date
    Jan 2011
    Posts
    112
    According to the article, it seems that this can only be done in Access 2007, by going to Home->Records and selecting "Totals" (the E shaped sum sign). However this is not a dynamic solution, i.e. you have to manually do this for each column each time you run the report.

    Do you know of any way to do this dynamically by modifying the SQL code so it does this automatically each time it's run, or is this outside the possibility of Access?

    Thanks!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Crosstab Query Bug
    By goodguy in forum Queries
    Replies: 19
    Last Post: 02-03-2011, 01:41 PM
  2. Crosstab Query Help
    By ksmith in forum Programming
    Replies: 7
    Last Post: 12-01-2010, 07:00 AM
  3. Crosstab Query
    By lukewarmbeer in forum Access
    Replies: 2
    Last Post: 08-13-2010, 05:10 AM
  4. Replies: 1
    Last Post: 07-30-2010, 10:28 AM
  5. Query - Crosstab ?
    By rob4465 in forum Access
    Replies: 1
    Last Post: 01-28-2010, 08:41 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums