By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
455,491 Members | 1,868 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 455,491 IT Pros & Developers. It's quick & easy.

Getting three highest values

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
do a top values query and group by player. Then get his totals.

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.