Solved Why is calculating MIN excluding Zeros so difficult?

[Kaloyanides]

I really don't want to know why, I want to know how.

How the hell???

Seems like it should be a simple thing to do...

Report : rptPickingSummaryByWeek
Query: qryPickingSummary3
Field: [DPerHour]

I tried: = DMin("DPerHour", "qryPickingSummary3", "DPerHour >0 ")

But that doesn't work.. I get an error.

The field is numeric. Not text.

I don't get it....

Hopefully someone can help... Giving up after a few hours. Really appreciate your help in advance.

 

[theDBguy]

But that doesn't work.. I get an error.

What was the error?

 

[Kaloyanides]

The Answer: =min(IIf([Total_Time_Order]=0, Null, [Total_Time_Order]))

 

[theDBguy]

The Answer: =min(IIf([Total_Time_Order]=0, Null, [Total_Time_Order]))

Glad to hear you got it sorted out. Good luck with your project.

I didn't get an error when I tried it.

 

[CJ_London]

not tested but perhaps it's additional space
"DPerHour >0 "