Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2013
    Posts
    8

    Unanswered: Sub Totals in Report

    Hi

    I am trying to add Order Totals in a database with a formula such as =sum([ExtendedPrice]) but this does not work ....can anyone tell me what I might be doing incorrectly?

    Thanks
    Shirl

  2. #2
    Join Date
    Jan 2009
    Location
    Kerala, India
    Posts
    183
    1. Open your Report in Design View.
    2. Select Group & Sort.
    3. Select OrderNumber for the Group.
    4. Select with Footer Section to display the Order Group Footer Section.
    5. Place your formula =sum([ExtendedPrice]) in the Order Group Footer Section. The formula will work in the Header Section also.
    6. Save the Report, Open it in normal view.


    Subtotal will appear for different items under the same Order Number.
    www.MsAccessTips.com (Learn MS-Access Tips & Tricks)
    Learn Advanced MS-Access Programming with sample VBA Code.

    All responses are based on Access 2003/2007

  3. #3
    Join Date
    Oct 2013
    Posts
    8

    Cool Sub Totals in Report

    Hi there

    Thanks for the reply. I did that before and it worked. Thanks so much. My error was in not selecting the proper footer and grouping.

    Shirl

Posting Permissions

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