Results 1 to 3 of 3
  1. #1
    cwitt11 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2014
    Posts
    10

    Need a formula to auto sum

    Hello, I was wondering if what I want to do is even possible? I have a form that calculates a Total Profit on each separate document. I would like to have a calculated field in the form that would keep a running total of all the Total Profit from each entry and display it in a text box. Does anyone know a formula I can use in this calculated field? Thanks, Carol

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,771
    This is difficult to do in query and form. https://support.microsoft.com/en-us/kb/290136

    Textbox on report has a RunningSum property so it is quite simple on a report.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    cwitt11 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jul 2014
    Posts
    10
    Thank you, I will try that.

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

Similar Threads

  1. Replies: 19
    Last Post: 07-13-2015, 10:15 AM
  2. Replies: 41
    Last Post: 05-29-2015, 02:58 PM
  3. Auto sum formula not working
    By data808 in forum Access
    Replies: 8
    Last Post: 07-04-2014, 02:17 AM
  4. Replies: 3
    Last Post: 11-04-2011, 01:50 PM
  5. Auto Run Report then Auto Email
    By jo15765 in forum Reports
    Replies: 1
    Last Post: 10-05-2011, 10:57 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