Combine and total query results

[thawstone]

The results of my union query of 2 separate tables looks like:

Name - Count of Participations

Joe Blow - 7
Harry Smith - 11
Kate Upshaw - 8
Joe Blow - 3
Harry Smith - 5
Kate Upshaw - 13

I need to combine the duplicate names and total their participations to make a report look like:

Name - Count of Total Participations

Joe Blow - 10
Harry Smith - 16
Kate Upshaw - 21

Any suggestions on how to achieve this? Details please.

 

[pbaldy]

A totals query. Start a new query with the UNION query as its source. Add both fields to the grid. Click on the Totals icon on the ribbon (looks like an "E"). Change Group By to Sum on the count field.

 

[thawstone]

Thanks Paul, that was so simple Tina Turner could have figured it out. I know about grouping and summing, but had lost consciousness of the fact that the sum function would automatically get rid of the duplicate names even though I used it earlier in the process.

 

[pbaldy]

No problem. I'll ask Tina tonight and see if she gets it.