Running Balance

  • Thread starter Thread starter JS
  • Start date Start date
J

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
 
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]
 
Back
Top