Calculation Fields with Null Values

R

Ridnaway

I have several fields on a form that are auto-populated with currency values.
I also have a Total-Charges field that sums up all these currency values.
The problem is that unless I have a value in every auto-populated field the
expression will not execute and the value will always be $0.00. I have tried
making the default value of the currency fields equal zero but it doesn't
work. Any thoughts?
 
K

Klatuu

Try using the Nz() function in your calculation. Be sure you use it on each
control and not the total:

= Nz(Me.txtCurr1,0) + Nz(Me.txtCurr2,0) + ......
 
Top