I am trying to add a subform into a form that will keep track of a customers payments and withdrawls. I want to be able to manually add the customers payments or withdrawls and have the table keep a running total. Can this be done?
So for Example the table would look like:
Date Desc Debit Credit Balance
7/1/03 Deposit 50.00 $50.00
Withdrawl -10.00 $40.00
With the Balance column automatically calculated.
So for Example the table would look like:
Date Desc Debit Credit Balance
7/1/03 Deposit 50.00 $50.00
Withdrawl -10.00 $40.00
With the Balance column automatically calculated.