Determine the time difference between two records

  • Thread starter Thread starter Nicholas Scarpinato
  • Start date Start date
N

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.
 
Back
Top