Average

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

Guest

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!
 
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
Click to expand...
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
 
Back
Top