average time

[hrov]

quick question. In a totals query i have a list of times. Hoe do i use the average function to give me correct average times? It is currently giving me the number 5.25E-02. I am looking for something like 01:15:09 for minutes:seconds:milliseconds

 

[ChrisO]

You will probably need to supply more information before someone can answer your question.

1. What data type are you using in the table field?
2. How are the sample times getting into the table field?

1: -
You could use a text data type but that would require more work than is really necessary.
You could use a date/time data type but you will eventually run into Access trying to be too helpful when formatting the display.
I would think that you should be using a double data type (preferred) because it matches exactly with the date/time data type without the display hassles (or a Long if the period can’t exceed ~ 45 days)

2: -
Internally, Access does not create date/times with a resolution greater than 1 second. Using API calls a resolution of 1 millisecond is available.
Therefore, it seems that the times are being entered into Access by some non-normal means.

So I think more information is required.

Regards,
Chris.

 

[ColinEssex]

And there's no need to post the same question twice. This has been answered on your other thread.

Col