Solved Why is calculating MIN excluding Zeros so difficult? (1 Viewer)

Kaloyanides

New member
Local time
Today, 18:30
Joined
Jan 28, 2015
Messages
13
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.
 
The Answer: =min(IIf([Total_Time_Order]=0, Null, [Total_Time_Order]))
 
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.

1732897618146.png


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

Users who are viewing this thread

Back
Top Bottom