Average of a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
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>
 
Back
Top