Sum by groups

[Lorlai]

I have data that needs to be summed together. It is presented below:

ID Qty
abc 12
abc 4
abc 5
efg 89
efg 1
efg 6
hij 21
hij 9

How can I get these all together by ID, so that the data will read:

abc 21
efg 96
hij 30



These columns are also amoung about 20 other columns that will need to be selected, if that makes a difference.

Thank you!

[vicrauch]

Here is the SQL for that type of query:

SELECT yourTableName.yourAlphaField, Sum(yourNumberField) AS SumOfyourNumberField
FROM yourTableName
GROUP BY yourTableName.yourAlphaField;

Because you did not give us field names, I used my own. your AlphaField is for those alpha characters, and yourNumberField is for the numbers you want to sum, by alpha group.