I am trying to add data from 3 fields in a query. This should be simple as I have used this many times before, but something is wrong. If the data in my fields is Val1= "1", Val2= "2" and Val3= "3" then I am building an expression that simply states Total Val:[Val1]+[Val2]+[Val3]

I keep getting the value shown as "123" in stead of "6" like I expect... why isn't the data being added?...