Could you store the 60 records, and just show your desired ones? I mean calculate the amounts and what they would be for the life of the deposit, and pick out only what you want to see.
just playing around...
nstart = 5000.00
nrate = .08/12
FOR i = 1 TO 60
nstart = (nstart * nrate )+nstart
? nstart
NEXT i
>Hi all
>
>I have this calculation to be done for a Cummulative Fixed Deposit. The thing is that the interest for only a given sub period is to be shown. For eg. the deposit is of 100,000/- @ 8% cummulative interest for a period of 5 years. I have to show what will be the interest say in the second year for the whole of the second year dated 01/04/2004 to 31/03/2005.
>
>Hope I have been able to explain the problem.
>
>Please advise.
Wayne Myers, MCSD
Senior Consultant
Forte' Incorporated
"The only things you can take to heaven are those which you give away" Author Unknown