Handling negative values...

[merciless32]

I am calculating field values in a report. How do I set a field to return a '0' if the value in that field is negative number?

 

[merciless32]

Never Mind....

Got it...in the Format portion I set the code to ;"0" This returns a '0' when the number is negative. Sorry to bother you guys.

 

[kbreiss]

Just wondering where at on the Format did you set it to "0"?

Thanks,
Kacy
________
LovelyWendie99

 

[merciless32]

I have the following code in the control source block of the text box:

=([Field1]-[Field2])

In the format block I have this code:

;\0


This places a "0" in the text box when the number is negative.