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 :)
>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
>If you need more info please ask I will supply it.
>Thank you thank you thank you.