I am trying to add the values of two fields in one table. Not sure how to get the SUM function to make this work.
SUM function two different fields in one table
Collapse
X
SELECT fielda+fieldb AS Total FROM table;
SELECT SUM(fielda)+SUM(fieldb) AS Total FROM table,
Comment