See also http://www.experts-exchange.com/Databases/MS_Access/Q_20756831.html
I need to calculate a running balance on a subform. On the main form I have a total amount due. The subform takes in payment amounts. See below:
Total Amount Due: $10.00
Date Paid: Amount Paid: Balance:
10/24/03 2.00 8.00
10/25/03 4.00 4.00
11/1/03 2.00 2.00
I can't get the balance to work. It needs to be that the first entry is Total Amount Due - Amount Paid = Balance. Every entry after that needs to be Previous Balance - Amount Paid = Balance.
Please help! I need this ASAP! Thank you so much!