query help 1

[angels2]

I am running a query with part numbers and totals in another column most part numbers are listed more than once and each has it's own total is there any way I can combine the part numbers so they only appear once and then give me the sum of all the totals I need to get down to one part number only used once but have the total of all under one part number
Thanks for any help

 

[DotNetGnat]

SELECT partno, sum(parttotal) as totsum from mytable
GROUP BY partno

-DNG