Access 2002

[melvin]

I am trying to figure out how to write a formula to get
an average of 3 fields from the query table.

column1 column 2 column3 Average of column 1 thru 3
35 20 20 25

 

[Tom Ellison]

Dear Melvin:

Why not:

(Column1 + Column2 + Column3) / 3

If any of the columns can be NULL, how would you want to handle that?
By averaging the other two (or one, or none if the others are null as
well?) or by just counting it as being zero?

Tom Ellison
Microsoft Access MVP
Ellison Enterprises - Your One Stop IT Experts