Average of a column

K

Kogle

I have a column that counts the days between contract received and lot in to office. I have tried many formula's but cannot get it right. All I want to do is get an average number of days from the column that counts.
I am still new to this and need help.
thanks
 
G

Gary Miller

Did you try the Avg() function?

=Avg([YourFieldNameHere])

Gary Miller
Sisters, OR

Kogle said:
I have a column that counts the days between contract
Click to expand...
received and lot in to office. I have tried many formula's
but cannot get it right. All I want to do is get an average
number of days from the column that counts.
 
J

Jeff Boyce

Kogle

What data type is your column? If you have a column that records "start
date" and another that records "stop date", why do you also have a column
that stores the difference? You can always calculate the difference when
you need it, and you don't have any headaches from all the synchronization
and validation code you'd need to add to handle a change in any of the three
(start, stop, difference) fields.

Good luck

Jeff Boyce
<Access MVP>
 
Top