Results 1 to 2 of 2
  1. #1
    Athar Khan is offline Advanced Beginner
    Windows 7 32bit Access 2013 32bit
    Join Date
    Mar 2017
    Posts
    63

    How to sum a calculated field on a report?

    In a Report, How to Sum a calculated field which (itself) sums up a field in a table. This calculated field (on which I want to set calculation) is created by another query.
    Can I use this formula in Report Footer?
    =SUM (SumOfExtendedPrice)

    Or should I refer to the name of the TextBox of this field on Report? for example:

    =SUM (txtSumOfExtendedPrice)

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,518
    If it's a field in the report's source query, you can sum it directly. You can't sum a control, so if the control you want to sum contains a calculation, you sum that:

    =Sum(Price * Quantity)
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Sum of calculated field in report
    By whisp in forum Reports
    Replies: 5
    Last Post: 02-12-2015, 02:56 AM
  2. Replies: 2
    Last Post: 12-30-2014, 01:32 PM
  3. Sum calculated field on Report
    By 54.69.6d.20 in forum Reports
    Replies: 5
    Last Post: 06-19-2012, 02:27 PM
  4. Replies: 5
    Last Post: 09-09-2011, 01:15 PM
  5. Sorting a Report by a Calculated field
    By mulefeathers in forum Reports
    Replies: 1
    Last Post: 05-22-2010, 08:21 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
  •  
Other Forums: Microsoft Office Forums