Average in report without null values

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

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.
 
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.
 
Back
Top