Query

[Paul Smith]

Copper 234
Copper 235
Copper 278
Gold 1234
Gold 897
Gold 998
Silver 543
Silver 521
Silver 601

I have a query that returns the above information, how do I amend it so that
I just get three rows, one for each metal showing the sum of the entries for
that metal?

I am sure this is pretty simple so any help from someone knowledgeable would
be greatly appreciated.

Paul Smith

 

[Sajeev]

hope this will help

select fieldone, sum(fieldtwo) from tableone group by fieldone

Thanks
Sajeev