Averages Calculations

[Guest]

I need to create a query that will give me averages on a list of numbers.

How can I calculate the averages, but ignore 0 or null values. Addtionally
if I am ignoreing the 0 value I don't want the record field to factored in
the average count.

e.g.

5
0
2
4

In this senario I would want the averages to be be caluated on the 3 records
with values in excess of 0., 5+2+4=11 11/3 =3.6

If I took the 0 value I would end up with an average of 11/4=2.75 - which is
what I don't want

Any help would be appreciated.

 

[Rick B]

One post per question, please.

 

[John Spencer (MVP)]

Answered elsewhere.

MyAverage: Avg(IIF YourField = 0, Null, YourField)