Calculating sum of multiple records to display 1 total sum

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Acct # Amt Due
123456 15
123456 20
445544 11
445544 6
789888 5
099999 4

I want to run a query that finds the total sum of each account # and
displays the record ONLY 1 time. So I want to display:

Acct # Amt Due
123456 35
445544 17
789888 5

etc.
 
What happened to 099999? Try
SELECT [Acct#], Sum([Amt Due]) as AmtDue
FROM tblSomeTable
GROP BY [Acct#];
 
Back
Top