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.