Results 1 to 9 of 9

Create Subtotal in Access 2010 Query

  1. #1
    alcharbonneau is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    5

    Create Subtotal in Access 2010 Query

    Good Evening

    I would like to create a subtotal in an Access 2010 query. As you will note from the attached query, record number 267488 and 267535 have entered leveral lines of values. I would like to create a subtotal column, I suppose, that subtotals the values for each record number.

    Thank you for taking the time to read and/or respond to this request.

    Al
    Attached Files Attached Files

  2. #2
    June7's Avatar
    June7 is offline Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    28,030
    This is what reports are for. Take advantage of Grouping & Sorting with aggregate calcs in footers.
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  3. #3
    alcharbonneau is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    5
    Thank you for responding.

    Can you recommend a good newbie reference on reporting writing in Access 2010?

    Thanks again.

    Al

  4. #4
    June7's Avatar
    June7 is offline Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    28,030
    Basic Access functionality. Start with Access Help for guidelines on report designer. Search the Help for:

    reports

    report design

    create a simple report

    create a grouped or summary report
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  5. #5
    alcharbonneau is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    5
    I'll give it a try.

    Thanks

  6. #6
    qa12dx is offline Advanced Beginner
    Windows 7 64bit Access 2007
    Join Date
    Nov 2012
    Location
    india
    Posts
    79
    make a new query, dont choose any tables, click on SQL (top left), paste the below code;

    SELECT Hosp_2011_NMRC.RPT_REC_NUM, Sum(Hosp_2011_NMRC.ITM_VAL_NUM) AS SumOfITM_VAL_NUM
    FROM Hosp_2011_NMRC
    GROUP BY Hosp_2011_NMRC.RPT_REC_NUM;

    run query.

    that's what u wanted?

  7. #7
    alcharbonneau is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    5
    Bingo. Thank you for your very helpful suggestion.

    Al

  8. #8
    June7's Avatar
    June7 is offline Moderator
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    28,030
    An aggregate query will give you summary data but if you want to still view the detail records that contribute to the sum, use a report.
    To provide db: Make copy, remove confidential data, run compact & repair, zip if large - 2mb allowed, attach to post. Attachment Manager is below the Advanced post editor window.
    If suggestion in this post resolves your issue, please use the Thread Tools and mark the thread as Solved!

    Debug!Debug!Debug! http://www.cpearson.com/excel/debug.htm

  9. #9
    alcharbonneau is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2013
    Posts
    5
    Yes, thank you.

    Al

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

Similar Threads

  1. How to Create Chart in Access 2010
    By braveali in forum Access
    Replies: 8
    Last Post: 04-21-2014, 10:07 AM
  2. Replies: 3
    Last Post: 03-06-2013, 12:33 PM
  3. Subtotal on Query
    By claysea in forum Queries
    Replies: 1
    Last Post: 02-17-2012, 08:56 AM
  4. Replies: 1
    Last Post: 09-28-2011, 12:24 PM
  5. Replies: 1
    Last Post: 08-11-2011, 12:52 PM

Posting Permissions

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