time between two records

[Doctor]

I will try to make this simple and clear.

I want to calculate the time between two records

Example:
ID1: TestTime1 10:00 AM, TestTime2 10:10 AM
ID2: TestTime1 10:11 AM, TestTime2 10:21 AM

I can tell by looking that there is 1 minute elapsed time between ID1
TestTime2 and ID2 TestTime1

I then want a report to show ID1: ElapsedTestTime
then next Record on the report I would like to show Elapsed TestTime and
ElapsedBetweenTestTime (Time between 1st Record TestTime2 and 2nd Record
TestTime1)

Thanks in advance

 

[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

If you don't mind read-only results, a subquery would be more efficient than
either of the two methods in the article.