Solved QUERY OR FUNCTION TO RANK (1 Viewer)

mercystone

Member
Local time
Tomorrow, 02:07
Joined
Sep 20, 2021
Messages
48
Hello everyone. I am humbly and kindly requesting for somebody to assist me rank the subjects in the description in the attached database. The query or function should rank subjects automatically as the mark is being entered for students. E.g student A ENGLISH 60, STUDENT B ENGLISH 70, Student C ENGLISH 100. SO THE RANK SHOULD BE
STUDENT DESCRIPTION MARK
1. STUDENT C ENGLISH 100
2. STUDENT B ENGLISH 70
3. STUDENT A ENGLISH 60
AND TO DO FOR ALL SUBJECTS AS THEY ARE ENTERED.
Thanks in advance
 

Attachments

  • STUDENTS (2).zip
    51 KB · Views: 59

Gasman

Enthusiastic Amateur
Local time
Today, 23:07
Joined
Sep 21, 2011
Messages
9,297
You sort by Subject and then Mark.
 

mercystone

Member
Local time
Tomorrow, 02:07
Joined
Sep 20, 2021
Messages
48
You sort by Subject and then Mark.
Thanks. But it would be great if there was a query or function which should sort it automatically.
 

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 07:07
Joined
May 7, 2009
Messages
14,607
i don't know which form, i used Student Examination detail form.
see the recordsource of the subform.
 

Attachments

  • STUDENTS (2).zip
    71.2 KB · Views: 55

Gasman

Enthusiastic Amateur
Local time
Today, 23:07
Joined
Sep 21, 2011
Messages
9,297
Thanks. But it would be great if there was a query or function which should sort it automatically.
Yes, it would be great if the software wrote itself, sadly we still have to do it.
arnelgp is the next best thing though.
 

mercystone

Member
Local time
Tomorrow, 02:07
Joined
Sep 20, 2021
Messages
48
i don't know which form, i used Student Examination detail form.
see the recordsource of the subform.
Thanks. Is there a way to sort subjectID automatically. It is working but I have to sort subjectID manually. I would like the user of database not to sort manually. I wish there was something like vba code, function or query. I appreciate what you are doing. Kudos
 

mercystone

Member
Local time
Tomorrow, 02:07
Joined
Sep 20, 2021
Messages
48
Yes, it would be great if the software wrote itself, sadly we still have to do it.
arnelgp is the next best thing though.
@arnelgp is genius. He has helped so many people in matters computer. He is blessed with knowledge. God will bless him abundantly.
 

mercystone

Member
Local time
Tomorrow, 02:07
Joined
Sep 20, 2021
Messages
48
Hello everyone. Kindly look at this updated database. Kindly anybody to assist me with the query to give out rank as indicated in the Student Examination Details(derived from sub form). As you enter marks the query or function to update the position as per subjects. Check the database. Thanks in advance.
 

Attachments

  • STUDENTS (2)-1.zip
    51.9 KB · Views: 57

arnelgp

..forever waiting... waiting for jellybean!
Local time
Tomorrow, 07:07
Joined
May 7, 2009
Messages
14,607
is this correct?
 

Attachments

  • STUDENTS (2)-1.zip
    136.8 KB · Views: 60

Users who are viewing this thread

Top Bottom