Determine the time difference between two records

  • Thread starter Nicholas Scarpinato
  • 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.
 
N

Nicholas Scarpinato

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculatting Time difference 1
calculating time differences between consecutive records 13
How can I find records based upon a date and time range while accounting for time zone difference 2
Time difference between two records 3
Calculating Time difference 6
Calculate working days between records 3
Calculate difference between records? 2
Difference between two queries 3

Top