Set Query if - Show 0

[jo15765]

Is there a way to set-up a query to where if the result is going to be a negative number to show 0 instead?

[pbaldy]

I'd probably do it on a form or report, but

IIf(YourCalculation < 0, 0, YourCalculation)