Sum of multiple text boxes on form

[djgeverson]

Hi there,

I am trying to add together 4 fields on a form to give total sumation. I have created the expression:

=Nz([txtprice],0)+Nz([txtshippping],0)+Nz([txtimporttax],0)+Nz([txtadditionalcosts],0)

But when values are entered into the appropriate txt boxes instead of adding all the values together to give a sumation, it just adds them together i.e. if the numbers in the text boxes are 3, 4, 5 and 6, I want to add them together to get 18, whereas the expression gives 3456!

Any ideas!

[jimatqsi]

NZ returns a string value. Try

Cdbl(Nz([txtprice],0))+Cdbl(Nz([txtshippping],0))+Cdbl(Nz([txtimporttax],0))+Cdbl(Nz([txtadditionalcosts],0))

Also pay attention to the formatting on the text box that will display this sum.

Jim

[djgeverson]

Thanks it worked first time!!