Rank data

[Cheveliar]

Now that my IIF statement works properly, I need to rank the data according to the best percentages. How do I create a field that numbers the records according to the best percentages?

example:

Player Wins losses PCT Rank
Player 1 2 0 1.00 ?
Player 2 6 1 0.86

 

[SgtJarrow]

What you ultimately want is merely a one-up number system in your query....you already have them in descending order by percent...so now you just want to add a column that shows a one-up number....search this site for autonumber in query or something similar for your solution..

****************************
Only two things are infinite, the universe and human stupidity,
and I'm not sure about the former. (Albert Einstein)

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com