How to get a running balance field on a bank ledger dbase
Posted on 2006-05-09
I have a dbase with the following fieldsL
ledger_id, ref, credit, debit, transaction_date, balance
the ledger_id is unique and primary and uses identiy seed.
I need to create either a calculated field or a trigger to calculate the running balance field
ie balance = previous row balance value field + credit field + debit field just like a bank statement.
Really need some help on what is the best way of doing this.