autorenewal

[cliff]

Hi, I am new to access but i have the following to complete. Please help me
out


Interest rate

scheme date period rate
FDR 1/1/2000 1 YEARS 6
FDR 1/1/2000 2 " 8
FDR 1/1/2000 3 " 12
FDR 1/8/2000 3 13
FDR 15/1/2001 2 9
FDR 15/1/2001 3 12.5
FDR 1/12/2001 2 7
FDR 1/12/2001 3 11
RAP90 1/1/2000 90 5
RAP90 1/8/2000 90 6
RAP90 15/ 1/2001 90 6.5
RAP90 20/5/2001 90 6
RAP90 1/12/2001 90 5

RECEIPT

SCHEME RECIEPT_DATE PERIOD AMOUNT
FDR 1/2/2000 3 10000
RAP90 15/4/2001 90 15000


I want to computer to automatically renew the receipt taking care of rate of
applicable as on maturidy date of the receipt. can u guide me write
programme to do this task


thank you in advances


cliffs