Min function Question

[Ray1127]

I have a report that displays Counts by Day every day is shown even if there are 0 for that Day. In the footer I have 4 lines of totals.

The First is a grand total Sum of counts
The second is an average of those counts
the third is the max count
the fourth is the min count. This is where the problem is I want the minimum count for the days that actually had a count. Not 0. Any Idea how I can get that?

 

[dhookom]

You could try something like:

=Min(IIf([YourUnnamedField]=0,9999999,[YourUnnamedField])

Duane
Hook'D on Access
MS Access MVP