View Full Version : MS Access Rank question

01-17-2006, 04:47 PM
I have a simple question that I can't figure out but I'm sure someone who is an Access expert would know.

I have reports that produce ranks for students based on their averages.
In these reports I have Rank, Student Name, and average.
I have reports for best to worst average and worst to best.

When I run the reports the rank number goes from 1 to whatever. However, I hoping to have the rank number be the same if the average is the same.

Example: the report shows this

Rank Name Avg
1 Smith 99.8
2 Taylor 98.7
3 Jones 98.7
4 Charles 96.5

How can I make the text box in the design view for rank show identical numbers if the averages are the same? So, the report would look like this:

Rank Name Avg
1 Smith 99.8
2 Taylor 98.7
2 Jones 98.7
4 Charles 96.5

Right now I have the control source for the text box set at "=1"

Anyone that knows the solution - if there is one- if you could please enlighten me, it would be appreciated.

01-20-2006, 03:22 AM
I don't know how to do it, but I suggest a Google Search Query. Go here (http://www.google.com/search?hl=en&q=MS+Access+Rank+)if you want to see Google's results on the keywords 'MS Access Rank'.

EZ Archive Ads Plugin for vBulletin Copyright 2006 Computer Help Forum