I have 2 tables, 1 for daily transactions and 1 for opening balances. I require a field that accumulates the opening balance to the daily totals. In this way i will get the daily balance of the account.
eg if the opening balance is 1000
|eff_date||daily total||accumulative total|