help with a query

[Todd]

I have this table:

ID Weight
1A 20
1B 30
2A 15
2B 20
3A 12
3B 80

I want to return this info:

Num Weight-A Weight-B Total-Weight
1 20 30 50
2 15 20 35
3 12 80 92

Is there an easy way to do this in a query?

I can't seem to get it right.

Thanks.