Omit zeros in calculation

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

Guest

Is there a way/formula to omit records with a zero value when calculating an
average on a report?
 
In the Report Footer section, add a text box.
Set its Control Source property to something like this:
=Avg( IIf([Amount] = 0, Null, [Amount]) )
Substitute your own field name for Amount.

This solution uses the fact that Access ignores nulls when calculating
averages.
 
Back
Top