Ranking in Access Table/Query/Report

[Ben Cherry]

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

[Rabbit]

You can use a subquery to count how many have marks larger than the student to get their rank.

[NeoPa]

Indeed. Always add one to the value ascertained of course for the ordinal number (rank).

[Ben Cherry]

thanks but what are the procedures, say after creating the query what do i do or which codes do i enter?

[Rabbit]

Well, after creating the query, you're done. The query is what ranks the records.

[NeoPa]

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.

[Ben Cherry]

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.

[Rabbit]

You have yet to show how you implemented our suggestion.

[NeoPa]

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.

[Ben Cherry]

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.

[NeoPa]

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?