Calculating fields in queries

V

VickiT

I have a calculating field in a query which uses the Nz
function and places the value of 0(zero) in the fomula. I
am then subtracting 1 field from another. All formulas
work until the inital value is zero then it returns only
the value of 0 instead of negative. It the number is
something other than zero the calculation returns the
correct negative number. Help...
 
J

John Vinson

I have a calculating field in a query which uses the Nz
function and places the value of 0(zero) in the fomula. I
am then subtracting 1 field from another. All formulas
work until the inital value is zero then it returns only
the value of 0 instead of negative. It the number is
something other than zero the calculation returns the
correct negative number. Help...
Click to expand...


THat's odd. Please post the SQL view of the query!
 
Top