Referencing previous value in same field

[Derek Brown]

Hi all

I have a date field that stores dates of events. The next event follows on
from previous event leaving a time value between events. How calculate the
difference between two events in the same field?

Thanks all

 

[Allen Browne]

See:
Referring to a Field in the Previous Record or Next Record
at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;210504

 

[Derek Brown]

Thank you Allen

See:
Referring to a Field in the Previous Record or Next Record
at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;210504

 

[Derek Brown]

Thank you Allen

See:
Referring to a Field in the Previous Record or Next Record
at:
http://support.microsoft.com/default.aspx?scid=kb;en-us;210504