AVERAGE - Null Value

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

Guest

Hi
I am trying to get the average for 4 columns in a table. When I run the
report that is linked to the query it is wrong, because it is counting the
"0" entries.

I have made my queryu using totals - AVERAGE function. How can I exclude
the "0" figures?

I am OK at access, but I would classify myself as advance, so type slow!

Thanks
 
Use an expression and get the average of it.

Avg( IIF([TableName].[FieldName]=0,Null,[TableName].[FieldName])) as
AvgWithNoZeroes

Or eliminate the zeroes by using a Where Clause (if you don't need the
records otherwise).
 
Back
Top