Calculating a new field using a formula

[mccambe21]

See table below:

Date UV


03/21/02 10.3
04/07/02
05/08/03

I want to use a formuale to calculate UV at each date after 03/21
i.e 04/07 UV = 10.3 * (1.06)^((04/07 - 03/21))/365
05/08 = calculated value from 04/07 * (1.06)^((05/08-04/07)/365)

Does anyone know how I can do this?
Thanks a million!

[pbaldy]

Here's a way to get the date from the previous record into the current record so you can work with it:

http://allenbrowne.com/subquery-01.html#AnotherRecord