Sample Header Ad - 728x90

Adding two columns results in concatenation instead of addition

3 votes
1 answer
2161 views
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.
Asked by user68849 (31 rep)
Jun 18, 2015, 08:05 PM
Last activity: Oct 31, 2023, 10:45 AM