problem with MS Access

[ErnieC]

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? it looks like it is concatenating it.

Does anybody know how to fix this issue?

[improvcornartist]

Sounds like the values are saved as text. You could probably convert before adding, such as CInt(Val1).