Query

  • Thread starter Thread starter Paul Smith
  • Start date Start date
P

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
 
hope this will help

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

Thanks
Sajeev
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Maybe a Crosstab Query 2
Multiple IIF In Query 3
Problems with a "Not" query 2
Query Revision - Help Required 4
Finding duplicate records in multiple queries/reports 1
Joining 3 tables into one (Union Query?) 6
Pick out the last word of text in Access query 2
Query to display highest totals 1

Back
Top