I have an access database for a football pool. I need to be able to show a "rank" for each player...like player A is averaging 10 wins a week, and player b is averaging 9 wins, and C is averaging 11. I want to be able to show stats:
Player Avg Wins Rank
A 10 2
B 9 3
C 11 1

I can sort the recodset in teh correct order, but how can I show "rank"?
Any help would be greatly appreciated.

Hi Lou,

If you show me what you have done so far or an example what you want to display I could help you. I think its a matter of placing the right recordset calls.

For example, think of a shopping cart with different users. Some users would be have a higher discount than others thus different customer categories (in your case different ranks).
When you make a purchase according to your user details customer category the right % discount.

ALT SOLUTION

You could also create a table and call it rank, and call the rank table in a sql statement WHERE rank = "URLstring" AND ranktable.rank = player.rank

Not to sure if im on the right path but if you were to show an example i would be able to help.

Regs
Al

Thanks allan for your response,
I am so bad at explaining whatI need. I have a table with numeric values. I can create a recordset to show all averages, and even sort them in desc order. But what I want to do is show the record number. So lets say USER XYZ is averaging 10th, and therefore the 10th record from teh recordset, how can I get it to display <b>10</b>??? I want to be able to show each user, his or her position or rank?
You can think of it as a "place" So i want each user to know what place they are in. In their own page, I have a spot where it shows them how many points they have, but would be really cool if I can say
"UserXYZ total points is &lt;%rspoints.fields.item(totpnts).value%&gt;
and your current rank is <b>10</b> out of &lt;%rsUsers_total%&gt;

Thanks again