Sum Query Question 1

[langnoi]

Let's say I have the following table with 2 columns:

Table = Account_tbl
1st Column = Account_name
2nd Column = Amount

How can I set up sum sql to get the total amounts for all the accounts in the tbls? I wanna get it so that it will display the totals for all the 'Smith' and 'Jones'.

Please advise.

thanks

 

[LogicalmanUS]

langnoi,

SELECT Account_name, SUM(Amount)
FROM Account_tbl
GROUP BY Account_name

Logicalman

 

[langnoi]

Thanks LogicalmanUS for your answer...your sql worked like a charm. FYI - I marked your answer as helpful/expert post thanks!

 

[LogicalmanUS]

langnoi,

Thank you, but it was my pleasure

Logicalman