Will not read $0.00

  • Thread starter Thread starter Russ via AccessMonster.com
  • Start date Start date
R

Russ via AccessMonster.com

help, trying to sum the tax field, works ok unless the tax is 0 then it will
not read $0.00 it is just blank
Have the default value to 0
Code is...
=(Sum(Nz([SalesTax])))
 
Do you have a format specified for the textbox?

You might also try

=(Sum(Nz([SalesTax], 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

updated field 3
I am trying to use the IF and SUMIF function on Excel 8
Calculation not working 2
calculate tax based on y or N 3
How to extract a few data elements from the following data 1
Help please 1
EU orders Apple to pay €13bn in back taxes 11
IIF statement 6

Back
Top