Access minimum time calculation

M

melric

I am trying to do an Access report measuring elapsed times in warehouse
product picking. I want to find the minimum time a person spends on a pick.
I tried the min function on the elapsed time in a section footer on the
report, but occasionally my elapsed times are zero (warehouse system glitch)
and this is what I get back.. If my report has a zero, I want to ignore it
and report the next higher minimum time. How do I get the minimum time
greater than zero?
 
M

Marshall Barton

melric said:
I am trying to do an Access report measuring elapsed times in warehouse
product picking. I want to find the minimum time a person spends on a pick.
I tried the min function on the elapsed time in a section footer on the
report, but occasionally my elapsed times are zero (warehouse system glitch)
and this is what I get back.. If my report has a zero, I want to ignore it
and report the next higher minimum time. How do I get the minimum time
greater than zero?
Click to expand...


Min(IIf(picktime > 0, picktime, Null))
 
Top