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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

qry FORMULA ISSUE 2
QRY FORMULA ISSUE 4
Exclude Multiple Zeros in Query 4
NZ function 1
Nz function 0
How do I query a calculated control? 1
Time in calculated field for shifts going past midnight 0
IIF Statement to return multiple values for a field - JohnW 3

Back
Top