Sum several text boxes on an access form

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • yinyang707
    New Member
    • Feb 2014
    • 1

    Sum several text boxes on an access form

    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
  • NeoPa
    Recognized Expert Moderator MVP
    • Oct 2006
    • 32662

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

    Code:
    "1" + "2" = "12"
    1 + 2 = 3

    Comment

    Working...