Amount of time spent on a record

[RR]

What would be a good way to keep track of how much time a form was opened to
each individual record?

Thanks

[Tim Marshall]

RR wrote:

What would be a good way to keep track of how much time a form was opened to
each individual record?

Use the on current event of the form, combined with the datediff
function. If all you're worried about is the last access, then you can,
if you wish, have a field in the table of concern that has the time
difference written to it.

Otherwise, create a table that joins with the table in question and you
can get a hiistory of who's been at what records and when.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

[RR]

Thanks for the answer.
What I would really like to keep track of is how long the form is open to
any record. For example if a record is open for 15 minutes during a phone
call to the person in that record, I would like to keep track of those 15
minutes.
"Tim Marshall" <TI****@PurplePandaChasers.Moertherium> wrote in message
news:cu**********@coranto.ucs.mun.ca...

RR wrote:

What would be a good way to keep track of how much time a form was opened to each individual record?

Use the on current event of the form, combined with the datediff
function. If all you're worried about is the last access, then you can,
if you wish, have a field in the table of concern that has the time
difference written to it.

Otherwise, create a table that joins with the table in question and you
can get a hiistory of who's been at what records and when.

--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

[Tim Marshall]

RR wrote:

What I would really like to keep track of is how long the form is open to
any record. For example if a record is open for 15 minutes during a phone
call to the person in that record, I would like to keep track of those 15
minutes.

The second approach would be what you want then. This will create a lot
of records, I would imagine. If you're not sure what to do, write back
and I'll air code it.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me