Adding similar records in a Query

[Pyeman]

I have a simple db for a golf league (I'm a novice user). We play every week and award around 25 cash prizes each tournament. Often a player can win two or more different prizes. I can easily query tables to produce a list of winners. What I would like to do is design a query that will find those multiple winners and total their cash winnings. For example I would like to add Ted Baker's two prizes together so that I can just have one entry for him in my query.

Many Thanks for any help you can offer

Cheers,
Dave

[June7]

Sounds like you want an aggregate GROUP BY query - there is a button on the QueryTools Design tab - looks like Sigma symbol.

Or build a report and use its Sorting & Grouping features with aggregate calc in textbox. This allows display of detail data as well as summary info.

Fairly basic Access functionality.

[orange]

In addition to June's good advice, you may want to research COUNT and SUM.

If you're interested in multiple "winners" then you would select records where the Count of occurrences is greater than 1, and for a total of their winnings, SUM (winnings). And GROUP by the associated Players.