Calculate an average in a field

[mechanic]

Can an average be calculated in a field in a single record from 3 other fields in same record. If so where does the formula belong?


example field name are as follows Test1 Test2 Test3 Average

31.5 30.6 32.4 31.5

[John_G]

It depends on where you want to use it. If you are thinking about putting the average in a table, don't. It's bad practice - calculate the average in a query when you need it.

In a form or report, you can use the formula for the average as a control source.

[mechanic]

OK Thanks.