Newbie Help with Access Query

[MartyMojito]

I am a complete newbie to Access. A friend has asked me if I can calculate the golfer of the year results of a golfer database. The member table has the member_id, competition_number, and score for each competition. One row per member. I need a query to sum the 5 best scores that each member has scored in the year.



Can this be done in one query?

Any help would be appreciated.

Marty

[KathyL]

I am a complete newbie to Access. A friend has asked me if I can calculate the golfer of the year results of a golfer database. The member table has the member_id, competition_number, and score for each competition. One row per member. I need a query to sum the 5 best scores that each member has scored in the year.

Can this be done in one query?

Any help would be appreciated.

Marty

You could do a query which sorts my member_id, then by score (descending), and you'd be able to see the scores from best, in descending order, for each member in sequence. This would be the simplest.

There are more complex ways to get what you want to a report, but I don't have time to go into the complex way, sorry.