calculating average time

K

ka

Hi,

I have a query in which I am calculating time between 2 procedures with this
formula:

Time1: [Procedure1]/60 & Format([Procedure1] Mod 60," ")

I am trying to create a report with all the entries. At the bottom of my
report, in the page footer, I would like to be able to have the sum of all
the times, averages, min, max...etc.

Each time I use the formula
=Avg([Time1]) (or a similoar one for the others),

I always get no value and just an ERROR where the info is supposed to be...

Any suggestions?
Thanks in advance.

Ka
 
D

Douglas J. Steele

As soon as you use Format, you've converted the value to a string, and
strings can't be averaged.

Average Procedure1, and do that transformation on the average.
 
K

ka

ahh!!....Thank you!

:)
--
Ka


Douglas J. Steele said:
As soon as you use Format, you've converted the value to a string, and
strings can't be averaged.

Average Procedure1, and do that transformation on the average.

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


ka said:
Hi,

I have a query in which I am calculating time between 2 procedures with
this
formula:

Time1: [Procedure1]/60 & Format([Procedure1] Mod 60," ")

I am trying to create a report with all the entries. At the bottom of my
report, in the page footer, I would like to be able to have the sum of all
the times, averages, min, max...etc.

Each time I use the formula
=Avg([Time1]) (or a similoar one for the others),

I always get no value and just an ERROR where the info is supposed to
be...

Any suggestions?
Thanks in advance.

Ka
Click to expand...
Click to expand...
 
Top