Average in report without null values

D

Dirk Rosier

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.
 
M

Marshall Barton

Dirk said:
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.
Click to expand...


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