Results 1 to 4 of 4
  1. #1
    Barb Murrin is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2017
    Posts
    8

    Calculate Sum of Field in Report Footer

    I want to have my report calculate a total in the footer, but I'm obviously not doing it correctly.

    I tried this in a text field:


    =SUM[Amt]


    This is the error message I receive:




    What am I doing wrong? (Is Sum even the correct function? Should I not be using a text field?) As you can see, I require basic, step-by-step instructions!



    Thanks in advance for any assistance.

    Barb

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    You error message is not displaying, can you write it out? That syntax looks correct, if "Amt" is the name that is on the report's record source. You can only use fields from the record source, not from the report.

    =Sum([Amt]) must be in the control source of the total text box.

  3. #3
    Barb Murrin is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2017
    Posts
    8
    Oops. Missed the parentheses.

    [Amt] is the field that contains dollar amounts of donated funds.
    The record source is the Donations query.

    I put this in the text box, which is in the report footer area:

    =SUM([Amt])

    When I go to Report view, the field displays "#Error". (At least it's not a separate error message that prevents the form view!)

  4. #4
    Barb Murrin is offline Novice
    Windows 10 Access 2016
    Join Date
    Apr 2017
    Posts
    8
    Oops. Missed the parentheses.

    [Amt] is the field that contains dollar amounts of donated funds.
    The record source is the Donations query.

    I put this in the text box, which is in the report footer area:

    =SUM([Amt])

    When I go to Report view, the field displays "#Error". (At least it's not a separate error message that prevents the form view!)

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

Similar Threads

  1. Replies: 1
    Last Post: 10-14-2016, 07:00 AM
  2. Replies: 2
    Last Post: 10-07-2016, 04:50 PM
  3. Force Report Footer to before Page Footer
    By Charles CL in forum Reports
    Replies: 15
    Last Post: 01-21-2016, 12:06 PM
  4. Replies: 2
    Last Post: 12-21-2013, 02:09 PM
  5. how to calculate FIELD IN REPORT
    By kimberleebecker in forum Reports
    Replies: 3
    Last Post: 12-04-2013, 01:45 AM

Tags for this Thread

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