Fields Concatenate insted of Add

[modum]

I wrote a query using SQL and I wanted the fields to add in the SELECT statement:



SELECT [Total FTPT]+[Total Contin] AS [Total Actives]
FROM Turnover;

There's actually a lot more in this query than this, but I stripped it down to make it easy to follow.

Why is it concatenating the number rather that adding them?!!! For example, instead of 90 + 7 = 97, I get 907!

Thanks,

Megan

[JoeM]

That tells me that [Total FTPT] and [Total Contin] are probably String/Text data types, not numeric.
How/where are those defined?

[June7]

Both fields are seen as text instead of numbers. How are TotalFTPT and TotalContin generated? Are these native fields in table or are they calculated in a query?

Try:
SELECT Val([Total FTPT])+[Total Contin] AS [Total Actives]

[modum]

I went back to the original table and I had defined these fields as text. I changed them to numbers and it's adding properly now. Thanks to everyone for the quick response!

Megan