I am new in access and this community too. I want to find the student rank on the basis of below criteria.
Criteria
1. If any student fails in any subject(s) they aren't qualify for any rank.
2. Find Top10 student rank in every class and section wise. Every student pass mark is 40 in each subjects.
3. If any student ties their obtained marks their rank should be equal.
4. All data should be entered through form their name is also Result Data.
Note: Result Data form is used as a sub form in Create Result form. Also these both fields are linked with ID (Link Master fields and Link Child Fields).
How to upload entire student obtained mark class 1 to 10 at a time?
It's urgent! For your kind support it will be highly appreciated. Thanks in advance.
Database attached
Criteria
1. If any student fails in any subject(s) they aren't qualify for any rank.
2. Find Top10 student rank in every class and section wise. Every student pass mark is 40 in each subjects.
3. If any student ties their obtained marks their rank should be equal.
4. All data should be entered through form their name is also Result Data.
Note: Result Data form is used as a sub form in Create Result form. Also these both fields are linked with ID (Link Master fields and Link Child Fields).
How to upload entire student obtained mark class 1 to 10 at a time?
It's urgent! For your kind support it will be highly appreciated. Thanks in advance.
Database attached