Problem is as following:
I have data in the following manner:
Accno Accntee Transtype Transamt Transdate Curbal
————————————————-
aa99 xxx w/d xxxx xx/xx/xx xxxx.xx
The problem is that “If Itype any accno the accountee(account holder’s name) and his opening
balance should appear in two cells. I am getting this. Now in a transaction table one may enter
any no of accnos i.e, one may do any no. of transactions. so when for the second time i am entering accno i am getting the previous remaining balance (The balance of the first transaction in computation with the opening balance) but for the second time when i enter the accno and i want the curbal to be the recent computed balanceon the opening amount it is giving me the second balance. i.e, i want to find the latest occurence of the accno(may it occur n times) i want the accno’s occurance at the nth time. Rather it’s cell address. suggest me any remedy.
