Well this is infuriating...bad totals on query

  • Thread starter Thread starter bugman
  • Start date Start date
B

bugman

I'm sure I am doing something very basic wrong. I have a table that has
the fields "TotalNewHours", "TotalOldHours" and "CustNum". I have
created a query to show these fields plus a total of the 2 fields. The
total coulmn has the following calculation "Expr1: ([Total New Hours]+
[TotalOldHours])". The total comes out wrong in most cases. If there
is a value for both "TotalNewHours" and "TotalOldHours" the calculation
is correct. If there is only a value for "TotalOldHours" no calculation
is performed. It looks like a "Null" issue to me, but how can I fix it?
 
Try changing the Null to a zero:

Expr1: Nz([Total New Hours], 0)+Nz([TotalOldHours], 0)
 
Nz([Total New Hours], 0)+Nz([TotalOldHours], 0)
Click to expand...
Yup, that did it. I was trying, unsuccessfully, to put the Nz expresson
in both of the fields that were to be calculated so the 0's would be
used in the calculation. This works better, thanks!
 
You must log in or register to reply here.

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

Count text values in a Access Field 0
Access Query problem 1
calculating running totals 2
Aggregate calculations on calculated query fields? 6
Adding the value of two fields when value is null 4
How to grand total expression value fields in query 1
Calculations in a Totals Query 4
running total of records in query 1

Back
Top