Hi Richard,
Thanks again for your assistance!
I learnt many things from the videos about ranking but it was a little hard for me to apply to my school project. I followed your instruction and did it accordingly but it never worked; it showed #Error.
I searched for other video in YouTube about the same topic, but all I could were your videos on this topic.
Let me explain my objective.
I have 25 students in each class. They have their annual examinations. They have total 300 points. I want to rank them accirding to the points they score. Suppose if Joe got 300 points of 300 points. He will be ranked 1st in 25 students, Sue got 297 points out of 300, she will be ranked 2nd and so on, till the last student with 140 points out of 300 will be ranked 25th in 25 students.
I have already created tables, forms, query for different classes. I just need to add the ranking field so that the student will be able to know their ranks when I issue them their progress report.
If it is possible, please explain it by help of a video.
Thanks again,
Zahid

---

Reply from Richard Rost:

I understand. That video explains how to use the DCOUNT function to create the rank you're looking for. There really isn't much more to it than that. I would need to see your database to tell you why you're getting an #ERROR message.