Average Calculations

[Robert]

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.

 

[Ofer]

Try this query

SELECT Avg(TableName.FieldName) AS AvgOfFieldName
FROM TableName
WHERE (((TableName.FieldName)<>0 And (TableName.FieldName) Is Not Null))