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.