calculating average time

[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

 

[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.

 

[ka]

ahh!!....Thank you!


--
Ka

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!)

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