Sums and totals with blank fields

  • Thread starter Thread starter Almost the weekend
  • Start date Start date
A

Almost the weekend

Question:
How can I sum values in a row when some of those fields
might be blank?
Also if all the fields that are to be summed were blank,
would there be a way to have the total column show up
blank too and not show a "0"?

Background info:
I have a query with multi number values in a row. These
number values are associated to three divisions (let call
them Support, Sales, and Training rating) that I want to
create a total for each division and a grand total with
the sum of the divisions' value. So. in essence in each
entry there will be several number values for Support that
I want to gather a total for and I want Supports total to
be added with the totals for Sales and Training.

Any ideas or suggestions would be appreciated. Thanks!
 
I'm not sure if this is what you are asking. If your problem is getting errors from adding nulls, or getting blanks when you want zero, use the Nz function. Nz([fld],0) will return 0 (the second argument) if your field is null or blank

Dion
 
Back
Top