Time and elapsed time

[melvincarter]

All,

As a newbie I am having difficulty determining how to record the time during different portions of a transaction:
1) Elapsed time from the termination of the last transaction to Now () when a new transaction is begun
2)"On Click" recording the ending time into (?) Form![table].[field]=Format(date, (as) "General Date" (I need to record time down to the seconds)

So far I have:

Private Sub Command34_Click ()
Dim [Data_Entry_Tabl e].[End_time] As Date
[Data_Entry_Tabl e].[End_time] = Nz(Format(Now() , "General Date"))

End Sub


please help a struggling beginner

[patjones]

I sense that it might be possible to do what you want, but I think we need some clarification from you. In particular, what makes for a transaction in your database? For instance, opening a form, entering some data, hitting a save button, closing form...

Pat

[melvincarter]

A transaction, in our case, is when an employee is to correct or finalize an electronic transaction that was flagged by a 'trigger'.

We are trying to find some performance measures. So, note that simply beginning a transaction with captured time and then ending it with time does not capture the 'queue' time. Queue time is important because it captures the time between ending one transaction and beginning another.

Ideally, three times would be captured: one as the employee finishes and single-clicks "next" to finish one and go to the next, a "start" button to begin time, and "end" time captured (on update(?)) as the info for the last field in the form in entered.

Time in queue = "start" [time] - "next" [time] (elapsed time before beginning a new transaction). Time of transaction = "end" - "start".

It would even be more efficient if they did not have to click any buttons and this info was captured behind the form (with "on update" or likewise).