Average in report without null values

[Guest]

Hi All,

I would like to calculate the averages on a report but without including
null values. I have based my report on a query that eliminates null values
for one field but now I need to do it for another field on the same report.

Any help would be much aprreciated.

Grtz,
D.

 

[Marshall Barton]

I would like to calculate the averages on a report but without including
null values. I have based my report on a query that eliminates null values
for one field but now I need to do it for another field on the same report.

I don't understand the problem. All the agregate functions,
including Avg, ignore null values.