trying to sum three calculated fields...

[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?

 

[KARL DEWEY]

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

 

[Ashes09]

Thank you!

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

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?