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.
Name: 2022-02-12.jpg Views: 9 Size: 112.1 KB ID: 47258" class="thumbnail" style="float:CONFIG" /> 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