Formula that uses prior record to calculate a new value

[mccambe21]

I have a number of transactions ($ amount), on different dates. I want to use the first amount in row 1 of table (or record 1) and then compound it at 6% up to date in next record. Any ideas? thanks.

[offie]

I dont't remember how to calculate compound interest but it's just a calculation that you can type in real quick. The only part is to find the amount of time from one date to the next. To do this you use DateDiff("d", [date1], [date2]) obvioulsy you want to change the names of the fields. "d" is days, "m" is month, "q" is quarters, "yyyy" for year.

How is your data set up? An example set would be nice.

I am assuming the dates are in different fields. If you want to do something like getting the first and last date (if they are in the same field) I would make a totals query first then base the calculations from that. Again, example would be nice.