If value is a negative number, display 0

[ScrmingWhisprs]

On my "timesheet" for my volunteer database, I have a textbox called HoursRemaining. It's control source is

=[HoursRequired]-[HoursCompleted]

That works great. Occationally however, the volunteer will complete more hours than required. Instead of displaying a negative number, I would like HoursRemaining to display 0.

Can this be done?

Thanks
ScrmingWhisprs

 

[boblarson]

=IIF([HoursRequired]-[HoursCompleted])<0,[HoursRequired]-[HoursCompleted],0)

 

[ScrmingWhisprs]

That code isn't working. First off, it was missing an open paranthesis, once I fixed that, all of my results are coming up as 0, except for the ones that are negative. So now it's only showing the negative values.

Am I putting this as the control source for that textbox?

 

[ScrmingWhisprs]

Nevermind!!! I figured it out!!! I just switched <0 to >0. It just dawned on me the logic of that statement.

Thanks for your help!!!
ScrmingWhisprs