Simple Query

[Cathy]

I have a Field Name "Time" and I want to subtract the
previous occurance from each value i.e.

10:01
10:03
10:15

I am trying to get a field which will shoe the subtraction
of the previous i.e.

0
2
12

Can you help?

Thanks,

Cathy.

 

[Allen Browne]

See:
Referring to a Field in the Previous Record or Next Record
at:
http://support.microsoft.com/?id=210504

To get the difference in minutes, use
DateDiff("n", ...