minimum number in report

[rmiell]

I have a field which represents a meter reading. Every once in a while, the meter fails, which results in the data entry person putting a zero into this field. When I generate a report based on this field, I want to generate 2 totals, a max amount in this field, and a minimum amount. The zero throws the minimum figure off, so I want to be able to go to the next valid amount that is not zero.

screen shot:






In this example, the zero amount by the time is ok, but when I generate the minimum amount in the footer, it would show up as 8335.

This would be the case only when there is a zero in the detail, that is, if all amounts are >0, no substitution would be needed.

Can anyone provide a simple way to do this within my report design?

Thanks in advance

PS: Access 2007

[rpeare]

in your minimum load formula put

= min(iif([IONKW] <> 0 ,[IONKW], null))

[rmiell]

Works perfectly. Thanks a bunch!!