Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Simply Want to Add Numbers in Form - Why Won't It? 1

Status
Not open for further replies.

Grippen

Technical User
Sep 3, 2001
24
GB
Hi,

I'm busy designing an Outlook form (Based on a Contact Form) to collect number based data. I've created several user defined number fields for the user to fill in with numbers and simply want to add them together an display the result on the form. I've done this successfully in several areas by defining a formula field but some have concatenated instead of adding (e.g. I want 10 + 10 = "20" but I get "1010").

It's driving me nuts!

Why? How do I get back to adding?

Thanks
 
Hello, Grippen.

Should convert the variable to number before adding, c = cint(a) + cint(b), if a and b are taken from input in a form which are usually taken literally as string.

regards - tsuji
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top