DateDiff with a Difference

[LdEckersley]

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

 

[Rich]

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