Hi

Can anybody help me with this problem, I know how to use the date difference with 2 seperate columns,
DateDiff("d",[Start Date],[End Date]) for example.
Is it possible to do this within the same column, by calculating how many days there are between the date on 1 row compared to the date on the next row down.
DateDiff ("d", [Date],[Date](next row down)).

If this is possible, any help would be great,

Thanks

Lee

Look up the PrevRecVal function. It has been posted here before if you can't find it in Access help.
HTH