Group by Query

Hi All,
I Have this problem:
I have a table like this

Code     Bank      Year       ID            Total
123       Bank1     2007       1            1000
123       BanK1    2007        2            1500
123       BanK2    2007        3            800
123       BanK2    2007        4            900
124       Bank1     2007       5            4000
124       BanK1    2007        6            1500

I need new table with aggregate data groupped by Code, Bank Year and
with total of Total:


Code     Bank      Year       Totale
123       Bank1     2007       2500
123       BanK2    2007        1700
124       BanK1    2007        5500

Thanks for your help.

Anluce