Pausing the timing


G

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.
 
Ad

Advertisements

M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top