Avoiding results with negative numbers

[Dale Cain]

How can I format a query to return either zero or null
when my original expression may return a negative number.

 

[Kelvin Lu]

Try

NewValue : If([Value]<=0,0,[Value]) inplace of [Value] where [Value] is the
field with the negative numbers.

Kelvin

 

[Dale]

-----Original Message-----
Try

NewValue : If([Value]<=0,0,[Value]) inplace of [Value] where [Value] is the
field with the negative numbers.

Kelvin

How can I format a query to return either zero or null
when my original expression may return a negative

number.


.
Thanks! I will plug it in.