We help IT Professionals succeed at work.

query

henryk123
henryk123 asked
on
Medium Priority
253 Views
Last Modified: 2010-03-20
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
Comment
Watch Question

SQL Server Data Dude
CERTIFIED EXPERT
Most Valuable Expert 2013
Author of the Year 2015
Commented:
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.

Explore More ContentExplore courses, solutions, and other research materials related to this topic.