By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,190 Members | 2,204 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,190 IT Pros & Developers. It's quick & easy.

Ranking in Access Table/Query/Report

P: 4
Hi I have created a tablein acess 07 with three fields; admno, name, and Mark/100. My problem is that i need to have a field with position of this students based on the marks i.e the one with highest mark be position 1 and the one with least marks to be the last. i hope to rank those which tie in marks as well. Kindly help
example. Table Name is "Students Marks"
Admno Name marks
1200 Jane 56
Jul 13 '11 #1
Share this Question
Share on Google+
10 Replies


Rabbit
Expert Mod 10K+
P: 12,359
You can use a subquery to count how many have marks larger than the student to get their rank.
Jul 13 '11 #2

NeoPa
Expert Mod 15k+
P: 31,433
Indeed. Always add one to the value ascertained of course for the ordinal number (rank).
Jul 13 '11 #3

P: 4
thanks but what are the procedures, say after creating the query what do i do or which codes do i enter?
Jul 14 '11 #4

Rabbit
Expert Mod 10K+
P: 12,359
Well, after creating the query, you're done. The query is what ranks the records.
Jul 14 '11 #5

NeoPa
Expert Mod 15k+
P: 31,433
Ben, You need to be much clearer and more precise about what you want. Rabbit's solution fits your question. If that's not good enough, that simply reflects the shortcomings of your question. If you need more help then make that clear in the question. I'm afraid your latest post doesn't come close to doing that.
Jul 14 '11 #6

P: 4
thanks but pliz help i'm not yet successfull take for instance students with marks 70,56,65,41,81,42,56 i wanted the query that will give their positions as 2,4,3,6,1,5,4 respectivelly, by creating a field that is. help.
Jul 19 '11 #7

Rabbit
Expert Mod 10K+
P: 12,359
You have yet to show how you implemented our suggestion.
Jul 19 '11 #8

NeoPa
Expert Mod 15k+
P: 31,433
Ben Cherry:
thanks but pliz help i'm not yet ...
When it's been made very clear what you need to do to get help, why would you not bother to do that, and instead post in a way that indicates you have not ever even read any of the threads put up to indicate what is, and is not, acceptable posting in the forums.

If you want further help then start by following some instructions. Try out what has been suggested and give feedback, or explain why you are unable to try it out. We're not about to simply do it for you, but we can respond to intelligent comments. "Pliz help" does not fall into that category.
Jul 20 '11 #9

P: 4
I have tried as much as i can, but i'm not a wizard in the use of Ms access. I though i could do much better if given procedures to follow.
Jul 24 '11 #10

NeoPa
Expert Mod 15k+
P: 31,433
Your best is to ignore what's already been posted? Sounds strange.

BTW. This is nothing to do with your competence at Access. We frequently deal with people who have little to no experience with it. This is to do with communication and attitude. Most people are prepared to put some effort in themselves, even if they struggle and don't get it right. Those that simply say "Do it for me." - especially those whose posts are full of errors (to indicate they couldn't even be bothered to read it themselves before sending it) don't even fulfil the requirements of posting on here.

So what type of member are you going to be?
Jul 24 '11 #11

Post your reply

Sign in to post your reply or Sign up for a free account.