Convert Negative values to zero

[Majic]

I am calculating downtime in query. Of course, when you have a
negative value is not considered downtime and I want to be able to
convert all negative numbers to Zero.

Please help me out

Thank you

 

[scubadiver]

I thought an update query would be appropriate (update to zero when the
criteria is less than zero) or you may be able to use the afterupdate event
in the form.

 

[Majic]

I thought an update query would be appropriate (update to zero when the
criteria is less than zero) or you may be able to use the afterupdate event
in the form.







- Show quoted text -

Thank you