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
Last activity: Oct 31, 2023, 10:45 AM