Getting Post Between Rank X And Rank Y

Hi,

I've got a table with football players, each player has a name,
id and a value. The value gets updated everytime the player
has played a match.

I don't have a rank field, and lets assume it's not possible to
add it.

I'd like to get, not the "top" players but the players from, say
rank 10 to rank 20. What I do now, is I get all the players (ordered by their value) and then loop thru the resultset.

Code:strSQL = "SELECT * FROM player ORDER BY player.score DESC;"rsPowerbabe.Open strSQL, adoConFor i = from_rank To to_rank Response.Write (rsFootballPlayers("name")) Response.Write (",") rsFootballPlayers.MoveNextNext

I think it would be more effective, if I could let access do the
hard work..

Any ideas?

Thanks in advance,

Rost