Adding two columns results in concatenation instead of addition

I need help using addition. When I do it populates using the concatenate function.

I used the following in my access database Total: [ANTI TERROR]+[Records] and instead of returning 1 + 1 = 2 it returns 11 - i.e. it's using the concatenate function.

Maybe you should use the type conversion function CInt()?

As in, CInt(expr1) + CInt(expr2). Does this fix your problem?

This is necessary if you haven't defined the column data type as a numeric type.

StackExchange Database Administrators Q#104507, answer score: 4