I have a table like 'account' in this account i have columns like ac_no, date,ac credit amount, int rate and net bal.
In this table i want to calculate interest rate every day. After debit some ammount in that account and based on the date.
I need recalculation for that, please help me out.
Thanks in advance.