Running Balance

[JS]

How do you create a report with a running balance such as:

Date Memo Check# Debit Credit Balance
1/5 100
1/6 50 50
1/7 60 110
1/8 10 100

 

[Allen Browne]

Text boxes on a report have a Running Sum property.

Add a text box to the report, and give it these properties:
Control Source Debit
Running Sum Over Group
Name txtDebitRS
Visible No

Add another one bound to the Credit field, with Running Sum turned on, and
name it (say) txtCreditRS.

You can now set the Control Source for your Balance text box to:
=[txtCreditRS] - [txtDebitRS]