D Dale Cain Sep 17, 2003 #1 How can I format a query to return either zero or null when my original expression may return a negative number.
How can I format a query to return either zero or null when my original expression may return a negative number.
K Kelvin Lu Sep 17, 2003 #2 Try NewValue : If([Value]<=0,0,[Value]) inplace of [Value] where [Value] is the field with the negative numbers. Kelvin
Try NewValue : If([Value]<=0,0,[Value]) inplace of [Value] where [Value] is the field with the negative numbers. Kelvin
D Dale Sep 18, 2003 #3 -----Original Message----- Try NewValue : If([Value]<=0,0,[Value]) inplace of [Value] where [Value] is the field with the negative numbers. Kelvin Dale Cain said: How can I format a query to return either zero or null when my original expression may return a negative Click to expand... number. . Thanks! I will plug it in. Click to expand...
-----Original Message----- Try NewValue : If([Value]<=0,0,[Value]) inplace of [Value] where [Value] is the field with the negative numbers. Kelvin Dale Cain said: How can I format a query to return either zero or null when my original expression may return a negative Click to expand... number. . Thanks! I will plug it in. Click to expand...
