controls on form not totaling when there is no amount

  • Thread starter Thread starter Gale
  • Start date Start date
G

Gale

I built a customer invoice form with a control that would give me a grand
total of the costs column, but it will only work if there is a numeric value
in each of the controls in the column. So I always have to add a 0 in each
control which makes the invoice look cluttered.

How do I total the costs column without adding a 0 to every control in the
column?

Thank you for any help you can offer.
Gale
 
Put the following expression in the control source of your grand total
control:
= Sum(NZ([NameOfYourCostControl],0))
 
Use the NZ function in your calculation around each of the items you are totaling.

Nz(Field2,0) + Nz(Field3,0) + ...
 
Back
Top