Calculating fields in queries

  • Thread starter Thread starter VickiT
  • Start date Start date
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...
 
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!
 
Back
Top