Calculating amount of time between interactions

  • Thread starter Thread starter bscarano
  • Start date Start date
B

bscarano

I have a table that has the time a transaction was created by a user.
What I want to do is calculate the amount of time between each
transaction. This can be done in a query or report.

user OrderEntryDate
Mark 11/5//07 10:00
Mark 11/5/07 10:09 (Difference of 9 minutes)

In this case, we assume that Mark spent 9 minutes with the first
person.

Can this be done?
 
You should have two bound fields to make this calculation.
StartDateTime and StopDateTime

User StartDateTime StopDateTime TotalTime
Mark 11/5//07 10:00 11/5/07 10:09 *see below

TotalTime would be an unbound calculated field with a ControlSource
of...
= DateDiff("n", StartDateTime, StopDateTime)
(if all your calcs are in minutes...)
would display 9.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 
Back
Top