>I did not explain it very well the first time. Let me try and clairify.
>When the record is written to the Access database, it will include a field named "Duration". This duration field will contain the length of time it took the user to complete the action, and it will be in the format of HHMMSS....
>
>Sample
>
> name date duration
>
>(John Doe 9/03/01 01:05:30)
>(John Doe 9/03/01 00:02:15)
>(John Doe 9/03/01 00:05:06)
>
> Total
>(01:12:51) <------This is what I am after.
>
>What is the best way to 1) record the time into the database? 2) total it in a vb Data Report?
OK, so the duration has already been calculated and you only need to save it, and you also need to total / avg. Then the date/time field type still works. Just save the duration value into a date/time field (no date) and whenever you need to add it for example, doing simple arithmetic as in (dt1 + dt2) will work right out of the field.
HTH
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement