Results 1 to 2 of 2
  1. #1
    Gina Maylone is offline Always learning
    Windows 10 Access 2016
    Join Date
    Jun 2013
    Location
    Afton, MN
    Posts
    544

    Incorrect totals in some records with running sum


    Good morning all! I have a Statement report with a subreport for member accounts. The sub report has running sum set to "over group". For those that have more than one line item, it is calculating incorrectly on SOME records. Images attached. The subreport is based on a table, so nothing fancy there. It is grouped by the member ID, the calculated balance field is: =Nz([dbamount],0)-Nz([CRAmount],0). The grand total calculation is: =Nz([totaldbamount],0)-Nz([totalcramount],0).

    Click image for larger version. 

Name:	runnngsumwrong.PNG 
Views:	14 
Size:	6.0 KB 
ID:	37663Click image for larger version. 

Name:	runningsumcorrect.PNG 
Views:	14 
Size:	5.9 KB 
ID:	37664

    Thanks in advance as always!

  2. #2
    Gina Maylone is offline Always learning
    Windows 10 Access 2016
    Join Date
    Jun 2013
    Location
    Afton, MN
    Posts
    544
    Additional information, if I view the report in layout view, the amounts are correct.???

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

Similar Threads

  1. Need help with running totals
    By Jackson in forum Access
    Replies: 6
    Last Post: 08-18-2016, 08:25 PM
  2. Incorrect Sum Totals on Single Field for Certain Records
    By accessapprentice in forum Queries
    Replies: 3
    Last Post: 09-29-2015, 02:28 PM
  3. Replies: 6
    Last Post: 09-14-2015, 06:05 PM
  4. running totals
    By challenger in forum Access
    Replies: 5
    Last Post: 08-11-2014, 02:36 PM
  5. Expression Incorrect in TOTALS query
    By SenSen in forum Queries
    Replies: 0
    Last Post: 02-29-2012, 08:46 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