Can someone suggest how i might create a continuous form that would have the following fields [startdate] [term] [value] [growthrate]
where
[startdate] = the day i wish to start the calculations
[term] = how long i want the calculations to continue (in this field i will enter 365 if i wish the make a calculation for each day of 1 full year)
[value] = my starting value
[growthrate] = how much i wish to increase the previous records [value]
So what i'm trying to do is have a form with a header as follows: (this i already know how to do)
[startdate] [term] [value] [growthrate]
9/8/20 365 $1000 $10
with 365 continuous records in 1 day increments that start with a [value] of $1000 for record 1, and $1010 for record 2, $1020 for record 3 ..... all the way until the end of the year (record 365).
I'm not sure how to set this up. Can anyone suggest a simple structure?
thanks in advance.