Form calculations.

  • Thread starter Thread starter Jwil
  • Start date Start date
J

Jwil

Hello,

I am adding two fields on my form but it only shows the result if a number
is placed in both fields. Is there a way to show the sum if only one field
has a number and the other field is blank? Assuming the blank is a zero and
it would be nice for it to be blank and not show a zero.

Thank You
 
I'm not sure why you didn't post the expression. Generically try:
=Nz(FieldA,0) + Nz(FieldB,0)
 
Back
Top