Recording the number of seconds it takes to complete a record

[ferrisj]

Iam trying to create a testing database that will allow me to record how quickly someone inputs a record. My assumption is I have to create a macro that sets a "Time Started" field to =now() and when I close the form set the "Time end" field to =now().

Then in a query I subtract the one from the other. However it does not seem to be giving me seconds. Just an answer of zero.

Any ideas?

 

[Golom]

Just subtracting will produce a value that is in days and fractions of a day. Instead, try

DateDiff ( "s", TimeStart, TimeEnd )

 

[PHV]

Another way;
Format(TimeEnd-TimeStart,"n:ss")

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886