calculating average time

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

ka - 30 Nov 2007 17:41 GMT

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

Reply to this Message

Douglas J. Steele - 30 Nov 2007 18:40 GMT

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.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Hi,
>
[quoted text clipped - 18 lines]
>
> Ka

Reply to this Message

ka - 30 Nov 2007 19:43 GMT

ahh!!....Thank you!

Signature

> As soon as you use Format, you've converted the value to a string, and
> strings can't be averaged.
[quoted text clipped - 23 lines]
> >
> > Ka

Reply to this Message