Adding text boxes 1

[zyphac]

I have several boxes in which I will be placing a value. Then the total text box. EX:

=([amnt]+[amnt1]+[amnt2]+[amnt3]+[amnt4]+[amnt5]+[amnt6])

Here is the problem: I will not always be entering values in all of them. This only work if I enter a value in all of the boxes. How can I rework this line?
Thanks zypha : )

 

[RickSpr]

The reason it doesn't work is that the fields you didn't enter data into have the value Null, which can't be used in arithmetic. To convert the Null values into zeros, use the Nz() function. For example,
Nz([amnt], 0)
evaluates to 0 if [amnt] is Null, otherwise it evaluates to [amnt]. Rick Sprague
Want the best answers? See faq181-2886
To write a program from scratch, first create the universe. - Paraphrased from Albert Einstein

 

[zyphac]

Ahhh, that works like a charm!!! Thanks. Also in my total text box after you input all your values, you have to click on the total text box to get the total, is there away for it to just show the toatal value with out clicking on the text box ?

Thank you very much!!!!zypha

 

[zyphac]

Disregaurd the last statement I figured it out, Thanks again!!!!!