Not adding in 0 to Averages 1

[Dauphy]

Hi!

When using the "average" function in Access Reports; is there a way to ensure that a field that contains zero not be included into an average?

Thanks for your help.

 

[MichaelRed]

Perhaps a way wwould be to replace the zeroes in the recordsource with Null.

Otherwise, do the Manual calc, checking the value in each record <> 0 before incrementing reccount. Then do the sum over the set and divide by the reccount.

MichaelRed
m.red@att.net

Searching for employment in all the wrong places

 

[Dauphy]

Yes, that'll work. Don't know why I didn't think of that myself. Just trying to make something hard that isn't. Long day ...

Thank you.