Link to home
Start Free TrialLog in
Avatar of Felix Kiprono
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","TotalMarks>"&[TotalMarks])+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
Avatar of Mike Eghtebas
Mike Eghtebas
Flag of United States of America image

It will be helpful to post:
- Sample data (electronic, not image).
-Expected result.
- Version of Access.

This way the solution will be tested before posting it back to you.

Mike
Avatar of Felix Kiprono
Felix Kiprono

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
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
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
thanks Rey