Newbies rshort50 Posted February 19, 2007 Newbies Share Posted February 19, 2007 I am crating a database to compute student scores for a contest. I have most of it done, but cannot find a way to easily/ automatically calculate their rank. For instances the highest score is 1, next highest 2, etc. Any help would be great. Link to comment Share on other sites More sharing options...
mr_vodka Posted February 19, 2007 Share Posted February 19, 2007 What is the structure of your tables? What happens where there is a tie? Do you need to store their ranking of only for display purposes. Any further details would help. Link to comment Share on other sites More sharing options...
Newbies rshort50 Posted February 19, 2007 Author Newbies Share Posted February 19, 2007 The table is set up with a variety of catagories that the scores are entered into. Then there is a field for the total score, which is calculated by adding the other together. I would like ties to show the same rank, with the next value being skipped. For instance a tie for 2nd place would show both records being 2, and no 3rd listed. The rank would be used to sort records, assign awards, and be exported. Link to comment Share on other sites More sharing options...
Genx Posted February 20, 2007 Share Posted February 20, 2007 Are there multiple score sets and or multiple totals? Link to comment Share on other sites More sharing options...
Newbies rshort50 Posted February 20, 2007 Author Newbies Share Posted February 20, 2007 Each student has one total Link to comment Share on other sites More sharing options...
Genx Posted February 20, 2007 Share Posted February 20, 2007 What happens if two students have the same score? Link to comment Share on other sites More sharing options...
Genx Posted February 20, 2007 Share Posted February 20, 2007 See if the attached helps. I've made a few assumptions -- I used a repeating field just to keep it simple, c_totalScore just has to be the total of all your fields. ranking.zip Link to comment Share on other sites More sharing options...
comment Posted February 20, 2007 Share Posted February 20, 2007 I would like ties to show the same rank, with the next value being skipped. ranking.fp7.zip Link to comment Share on other sites More sharing options...
Genx Posted February 20, 2007 Share Posted February 20, 2007 Oops.. I always seem to miss something don't i. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6268 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now