Convert Negative values to zero

  • Thread starter Thread starter Majic
  • Start date Start date
M

Majic

I am calculating downtime for testing times. I need to be able to
convert any negative number to zero. I am using the query for
calculations.
If anyone knows how to write the code please help me on this.

Thank you
 
Why? If the value is negative, isn't that telling you something?

If your calculation of "downtime" turns out negative, either something's
wrong with the calculation or you've invented a time machine <g>.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Why? If the value is negative, isn't that telling you something?

If your calculation of "downtime" turns out negative, either something's
wrong with the calculation or you've invented a time machine <g>.

Regards

Jeff Boyce
Microsoft Office/Access MVP







- Show quoted text -
Click to expand...

There is nothing wrong with the data and nothing wrong of getting
negative numbers. We have testers that they suppose to spend certain
time on testing products and after that certain time will be
considered downtime. However, if they finished before that time, then
we do not want to considered it as downtime.

Thank you
 
Ah! So the tester is given, say, 10 minutes, and anything over that is
considered "downtime"?

I'll play devil's advocate here ... if a tester were given 30 jobs, each
scheduled for an hour, and took 1:01 for 29 of them, and finished the 30th
in 10 minutes, the TOTAL time would be under 30 hours (30 X 1 hr), but the
tester would get "dinged" for running over on 29 of 30 jobs?!

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Back
Top