Creating a Report with averages

[ZeoGel]

I have a query i am using to generate a report but my averages are getting diluted because some of the feilds have 0 which shows no data in them but it is being counted when doing the averages how can i fix the averages to skip all feilds that have 0 in them?

 

[dhookom]

Try:
=Sum([FieldA])/Abs(Sum([FieldA]<>0))
If they might all be 0 then
=IIF(Abs(Sum([FieldA]<>0)) = 0, 0, Sum([FieldA])/Abs(Sum([FieldA]<>0))


Duane
MS Access MVP

 

[ZeoGel]

Man this is on the money thank you kind sir for you knowledge


Very Greatful
Zeogel