Determine the time difference between two records

[Nicholas Scarpinato]

I have a report I'd like to generate that will tell me the time between each
transaction in the database for a user, and the average time between
transactions. I'm having trouble figuring out how to do this. The field in
the table is called EntryStartTime. What I'd like to do is sort the start
times in ascending order, determine the time difference between the first two
records, and then continue to the second and third, third and fourth, etc. I
have a feeling the answer is probably really simple, but my brain isn't
working yet this morning. I'd like to try to avoid doing this with code if I
can.

 

[Allen Browne]

See:
Subquery basics: Get the value in another record
at:
http://allenbrowne.com/subquery-01.html#AnotherRecord

--
Allen Browne - Microsoft MVP. Perth, Western Australia

Reply to group, rather than allenbrowne at mvps dot org.

in message
news:[email protected]...

 

[Nicholas Scarpinato]

A couple minor modifications and that worked perfectly. Thank you Allen.