measure elapsed time between button presses.

[efandango]

I have a form that creates a new record each time a button is pressed.

The form is memory jog type 'reveal answers' form, which reveals the answer
from a sequenced and fintite set of pre-determined list of answers by copying
the hidden records to a new form whereby they are displayed on a continous
form.

I want to be able to measure the time in seconds between each button push
(or record creation). and display those times on a text field for each
record. I also want to be able to find the total elapsed time it took to
complete each form (based on the last record being created)

my fields are

[Run No]
[Timer_pressed] (this records the time the button was pressed)
[Btn_Timer_Elapsed] (this displays the result for each button press)

at the moment, i have the first part working where I have the 'Now()' value
assigned to the [Timer_pressed] field, but I can't figure out how to say,
take this time and compare it against the previous record's time to get the
result.

How would I go about achieving this?

 

[Wayne-I-M]

Hi

Have a look at Douglas Steel's and George Nicholson's answer regarding
refering to a the previous record.
http://groups.google.com/group/micr...a/e2b33623ec5f01bc?lnk=st&q=#e2b33623ec5f01bc

I'm not sure about your button press action. You could use a field with the
default set to Now() so giving you the time the record was created. But if
you'res works then use that - just an idea.

Good luck