Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2006

    Arrow Unanswered: Running Sum in Report

    i have an accounts report and a sub report called opening balance which shows the sum of total amount of the account as opening balance .it goes like

    opening balance 100
    ------------------------------- Amount Current Running sum
    ------------------------------- 200 1200
    --------------------------------- 300 2800

    You can see the current running sum is not printing correctly

    currently i have a text box in which running sum property is set to over all and in the control source i have added =report!openingbalance!txtopenbal+amount but it is not calculating correctly . does anyone know what is the problem

    Last edited by stocks159; 01-14-07 at 17:16.

  2. #2
    Join Date
    Nov 2004
    out on a limb
    Provided Answers: 59
    probably best to do this using some code in VBA that sits behind the report
    zero the running sum in the account group footer event (forget which one)
    set some code in the detail.format event that adds the current value to the running sum
    then set some code in the group footer format event that assigns that running totoal to a control in the footer... that will give you the account closing balance.
    I'd rather be riding on the Tiger 800 or the Norton

Posting Permissions

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