trying to sum three calculated fields...

  • Thread starter Thread starter Ashes09
  • Start date Start date
A

Ashes09

I am attempting to add the total of three calculated fields; however, the
total will only calculate if there is a figure in ALL three of the fields. If
only two of the fields are filled, the final total will not calculate.

Suggestions?
 
Thank you!

KARL DEWEY said:
Use the Nz function --
Nz([TheField], 0) to place a zero instead of the null.

Ashes09 said:
I am attempting to add the total of three calculated fields; however, the
total will only calculate if there is a figure in ALL three of the fields. If
only two of the fields are filled, the final total will not calculate.

Suggestions?
Click to expand...
Click to expand...
 
Back
Top