Felix Kiprono
asked on
Ranking Students in Ms Access based on given Criteria
Hello. I have a students Database expected to produce students examination report cards. I have StudentName, Class(Class1, 2 3 & 4), Semester (Semetser1, 2 & 3), ScoresInVarious Subjects, TotalMarks, Rank.
I used the formula =Dcount("*","tblExams","To talMarks>" &[TotalMar ks])+1 but the problem is that it only display a rank based on the all four classes instead of ranking basing on a particular class and semester. Plz help on how I can achieve that. Thank You
I used the formula =Dcount("*","tblExams","To
ASKER
Version: Ms Access 2010
Sample data and expected results
Adm Name Semester Class Marks Rank
11 Tam 1 1 500 1
12 Tem 1 1 400 2
13 Tim 1 1 300 3
14 Tom 1 2 500 1
15 Tum 1 2 100 2
11 Tam 2 1 400 2
12 Tem 2 1 500 1
13 Tim 2 1 200 3
14 Tom 2 2 200 2
15 Tum 2 2 400 1
Sample data and expected results
Adm Name Semester Class Marks Rank
11 Tam 1 1 500 1
12 Tem 1 1 400 2
13 Tim 1 1 300 3
14 Tom 1 2 500 1
15 Tum 1 2 100 2
11 Tam 2 1 400 2
12 Tem 2 1 500 1
13 Tim 2 1 200 3
14 Tom 2 2 200 2
15 Tum 2 2 400 1
1) In the query producing the result, order the query by Class Asc and then by Marks Desc.
2) Also, post the SQL of your query here for a close examination.
How to get SQL of the query: Open your query in design mode, On the ribbon, select View (A triangle & pencil image) to select SQL to copy and past its content.
I have made a sample table but I will wait for your reply on 1 and 2 above.
Mike
2) Also, post the SQL of your query here for a close examination.
How to get SQL of the query: Open your query in design mode, On the ribbon, select View (A triangle & pencil image) to select SQL to copy and past its content.
I have made a sample table but I will wait for your reply on 1 and 2 above.
Mike
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thanks Rey
- Sample data (electronic, not image).
-Expected result.
- Version of Access.
This way the solution will be tested before posting it back to you.
Mike