Function(Compounding interest )

Given the criteria you'll have to create your own

function. It's both fun and educational. The first step

is to get the formula right. The formula you have does

not consider time, it's therefore useless. Come back with

a formula and I'll put it to code. Even if it IS a

homework assignment :)

Quote:

>-----Original Message-----

>I need help. I want to run a report in Access and get a

>cumulative interst rate. e.g.first record, date: 1/1/02

>interest: 5%,next record date:2/1/02 interest:6%, next

>record date:3/1/01 interest:7%. after a report the

>cumulative interest rate would be : (1+5%)*(1*6%)+(1+7%)-

>1=19.091%. Is there a function for this, If not then how

>can I edit the sum function in VB to do this? Please

help.

>If you need more info please ask I will supply it.

>Thank you thank you thank you.

>.