Getting three highest values

[Elmo]

Hi there,

I have a table with sporting events and the scores per event for each
member. Each member partakes in at least 6 events per year.
Question 1, how can I find and sum the three higest scores per member for a
year and get a total. (this total will determine the ranking of the member
for the event)
Question 2, How can I exclude members from question 1 who has not
participated in at least 4 activities per event.

Example:

Player 1 plays 6 cricket matches for the year. He scores 11, 55, 37, 0, 48
and 8 respectively for each match.
I need to add the three best scores, 55 + 37 + 48 = 140 (this should be done
for each player and then based on the sumed value, their ranking is
determined.

Player 2 plays only 3 matches. He scores 75, 30 and 29. He did not play a
minimum of 4 matches and therfor does not qualify.

Any ideas on how to do this.

Thanks

Elmo

[pietlinden@hotmail.com]

Re: Getting three highest values

do a top values query and group by player. Then get his totals.