Sum amounts

[wikus]

I am trying to create a query to add amounts for all of the same account numbers. I have a list of account numbers with amounts. The account numbers appears multiple times in the list. I need a list of account numbers with totalled amounts for each account.
Any help would be appreciated.

 

[Joe4]

What you want is an Aggregate (Totals) Query.

Take a look at Access' built-in help files, they have examples and instructions on how to create one.

 

[wikus]

Thanks Joe