Sum of numbers in same table 2

[Allilue]

I have a table which contains 2 columns. The first column is a 4 digit number which may have duplicates. The second column is also a number which represents a count. I would like to take the duplicates in the first column and sum the second columns for which there are duplicates. For example:

Column1 Column2
0000 52
0001 10
0001 8
0002 41
0003 55

I want it to find that 0001 has a duplicate and to add the numbers in the second column (10+8) so that the resulting table is this:

Column1 Column2
0000 52
0001 18
0002 41
0003 55

I can only think of really long and manual ways to do this. Is there something easier?

Thanks!

 

[PaulF]

use a query with the Totals turned on (Click on the funny looking E on the toolbar). Set Column 1 Total to Group by and Colum 2 Total to Sum. Ensure Column 2 is numeric, and if not use Val(Column 2) instead.

PaulF

 

[Allilue]

.....Thanks.

Sounds too easy now that I think of it.

Thanks Again!
Allison