Using Top Values in a query

[Kingspur]

Hi guys and girls,

I am an absolute beginner with Access so please be gentle with me lol

I have a database with Players Names, Tournament Names and Points Scored.

Each player enters different tournaments and scores different points depending on how far they progress through the tournament.

In order to work out their ranking, I need to get a sum of their points. However, only the top ten scores are counted for their ranking.

I have tried using the Top Value in points, but this only returns the top ten overall points scored by anybody in the year.

I need the top ten per player to be displayed.

Is there anyway of doing this?

If there is, please could you explain in as simplest language as possible as like I say, I am brand new at Access so know very little about how it works.

many thanks in advance for taking the time out to look at this and hopefully it is not too difficult a problem to solve.

 

[pbaldy]

I've used the query here:

http://support.microsoft.com/kb/153747/en-us

 

[Kingspur]

Many thanks for that
I've tried Option 1, but when I try to run the query, it just hangs forever and crashes.

which is quite annoying really

 

[Kingspur]

Ok - So I've cut down my database to a manageable level and tried option one again.

This has resulted in showing just the 10 highest scores overall whereas what I was trying to get was per player

I think I must be doing something wrong

 

[pbaldy]

Can you post the db?