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) + ......
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Zeros Showing in Form Field 4
Help with an expression to calculate a profit from one of three fi 2
How do I create a form totalling several values from several tabl. 1
Sum Calculated Field Question 1
Need help setting up a Parent form with three subforms 8
Adding the values of multiple fields 1
custom currency symbol independent of regional settings 1

Back
Top