Help with adding values in Access 1

[3des]

I am attempting to create a simple expression that adds several seperate line items together. But the result is the value is each value listed togther, not the sum of them. Example sum1=1 sum2=1 sum3=1, my current addtion (=sum1+sum2+sum3)will give me the result of 111, what Im looking for is the result of 3.

 

[Norris68]

You are concatenating strings, which is why you get '111' as your result. Either change your data types to numeric (Long) or use the Val() function e.g. =Val(sum1)+Val(sum2)+Val(sum3)

 

[3des]

Norris68, Thank you for your assistance. The "Val" function worked perfectly. Thank again.