Pausing the timing

[Guest]

I am currently creating a database that is going to be used to track the
productivity of a department. Right now I have it set up that it will time
how long it takes to process a transaction. There are some instances when
the transaction that is being processed needs to be suspended until a later
time. What would be the best way to track the length it takes to process
these transactions without counting the time it was suspended.

 

[Michel Walsh]

Hi,


Filling a table in another db? Fill the starting time and ending time for
each transactionID, one sequence start-stop, start-suspend, resume-end, per
record and when appropriate, just SUM( ending-starting) with a GROUP BY
transactionID.



Hoping it may help,
Vanderghast, Access MVP