[AccessD] total of sum

Hello group,

i need to make an presentation of some figures for later this afternoon. I had a query that made a sum of numbers as a total, but i can't find it right now. Can You give me a hand?

i have

diag         number
biopt         5
biopt         7
biopt         2
ascites       4
ascites       6


i need

diag         Total
biopt         14
ascites       10

Thanks

Pedro Janssen