Calculating sum of multiple records to display 1 total sum

[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.

 

[Duane Hookom]

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