can someone help me to write a query that will sum the information across the row and down the column (sum) in ms access table
a b sum
1 10 11
2 20 22
total_all
I tried the following
select a,b, sum as (a+b) from table1
the error i get :
The SELECT statement includes a reserved word or an argument name that is misspelled or missing, or the punctuation is incorrect.
Josef01
0
Newbie Poster
Recommended Answers
Jump to Postthe correct statement is:
SELECT a, b, sum(a + b) from table1
sum is an existing method that returns the sum of the passed items
All 3 Replies
Reply to this topic
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.