Totaling Multiple Rows

[Siiig]

Hey Everyone,

This feels like something that should be simple, but I'm not having any luck approaching it.

Data:

ID	Available	Warehouse
001	5	000
001	4	001
001	3	002

I'd like to take this information, and wind up with...

001 12

I've done things like CONCATENATING this data, which this forum actually helped me out with, but it seems like this shouldn't be so complicated?

Thanks!

[pbaldy]

A totals query:

SELECT ID, Sum(Available) As TotalAvailable
FROM TableName
GROUP BY ID

[Siiig]

Ahhh! I had one of my columns set to "Group By" instead of "Sum" and another set to "Group By" instead of "Where"

No wonder it started breaking it out instead of adding it!

Thank's for the point in the right direction pbaldy.

And off topic, currently reading Atlas Shrugged. Really enjoy it so far ^^;

[pbaldy]

Happy to help!

I'm due for a re-read myself; it's a bit of a bear to read, but worth it IMHO. Just watched the second movie.