Sum several text boxes on an access form

yinyang707

New Member

Join Date: Feb 2014

Posts: 1
#1

Sum several text boxes on an access form

Feb 8 '14, 03:58 AM

on my form i have several text boxes and a total text box, in my total text box when i add 1+2 in my other text boxes the total comes up 12 instead of 3
Tags: None
NeoPa

Recognized Expert Moderator MVP

Join Date: Oct 2006

Posts: 32662
#2

Feb 8 '14, 04:06 AM

That's because you're adding strings together instead of numeric values.

Code:

"1" + "2" = "12" 1 + 2 = 3
Comment

Comment