Field to calculate Time Open?

[Roger Burns]

Hi

I am currently developing an Access database that will be
used to log all calls to an IT Helpdesk, distribute them
accordingly to 2nd line support and then provide reporting
to ensure that all Service Levels are being adhered to.

In order for this reporting to work there are two time
related fields in the database; one that keeps the SLA for
the specific type of call (a fixed figure) and the other
that basically is intended to act as a timer to log how
long a call is/was open for. I want this timer to start
when a job is opened and keep counting until it is
closed. When it is closed I still want to see how long it
was open for. I suppose that essentially I want a
stopwatch kind of thing but have no idea how to configure
this as a field in Access?

What is the best way to handle this second field?

Any help much appreciated.

Roger

 

[Roger Carlson]

I would not store the elapsed time in a field. I would have two fields
StartTime and EndTime. When you open a new record (for a new call) it would
use the Now() function to put the date and time in StartTime. When the
record is closed it would use the Now() function to store the date and time
in the EndTime field. Then to see how long, you can always find the
difference between the field with the DateDiff function.

Now, exactly how you implement this depends on exactly how your application
it written, but that's the over-all idea.

 

[Guest]

Thanks Roger

This does help a bit. The overall idea that you have
illustrated was similar to how I originally had set it up,
the only bit missing was the DateDiff function as I did
not know that this existed! Thanks.

Roger