gcapp
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.
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.