Automated Elapsed Time

[Guest]

I have two fields one called Starting_Time and the second Ending_Time, both
are Data Type (short date), on the caption of Starting_Time I have Now(), so
when I go to a form and input my data, as soon as a create a record the time
goes into the Starting_Time field (wich that is what I need), but my question
is How can I store the elapsed time in the field Ending_Time. In other words
I want to keep track on how many minutes does it take to capture all the
input data of each record in the data base.

 

[Lynn Trapp]

You need to do it in a data entry form. In the BeforeUpdate event of the
form put the following code.

Me.Ending_Time = Now()

Then you can use the DateDiff function to calculate the elapsed time.

DateDiff("n",[Starting_Time],[Ending_Time])

--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List: www.ltcomputerdesigns.com/JCReferences.html

 

[George Nicholson]

Maybe something in the Form_BeforeUpdate event like:

If Me.NewRecord Then
Me!Ending_Time = Now()
'(or, if you really, really, really insist on storing a calculated value...)
Me!Ending_Time = Now() - Me!Starting_Time
End If

HTH,