Average

[NTXCoog]

Using Access97, is there an easy way to average multiple fields in the same record. For example, if I have fields D1, D2, D3, D4, & Average. I want to do an update query that will put the average of D1-D4 into Average

Thanks!

 

[NTXCoog]

As a follow up, is there a way to average the non-zero values in the fields?

 

[John Parkinson]

Create a query that includes all of the fields you wat to
average.

Create an expression that will total and the average your
selected fields.

Expr1: AVG([D1]+[D2]+[D3])

John Parkinson

-----Original Message-----
Using Access97, is there an easy way to average multiple

fields in the same record. For example, if I have fields
D1, D2, D3, D4, & Average. I want to do an update query
that will put the average of D1-D4 into Average