Calculation Fields with Null Values

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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) + ......
 
Back
Top