query

hello,
how can I sum values from two fields (same table) in access query
ex query view:

Field 1     Field 2       (what expression suppose to be here)
Table1     Table1

If I add [field1]+[field2] i have fields togethet instead sum

thx

henry
henryk123Asked:
Who is Participating?
 
Jim HornConnect With a Mentor Microsoft SQL Server Developer, Architect, and AuthorCommented:
SELECT Field1 + Field2 AS MakeUpANameHere
FROM Table1

This works assuming that Field1 and Field2 are both numeric data types.  
If they are text, you'll need Val(Field1) + Val(Field2), and possibly re-assess why they are not numeric in the first place.
0
All Courses

From novice to tech pro — start learning today.