Timer display

[drock99a]

I am wondering if this is possible. Is there any way to have access keep running total in hh/mm/ss format of items entered in a table. For example we have a problem call data base. There is a field in the table that is for closing the call. I would like to keep a running total of how long calls have been opened without a resolution. Any suggestions?

 

[bat17]

=Now() - [YourDateTimeField] will give the diffence. you will need to refresh the form to update the value though. You will probably want to wrap it in an if() function to zero it if the call has been closed.

Peter