Ranking of Student based on their Mark and Average...

[nine05]

Hello,

I'm new to ms access can someone help me how to query the example in the image below.


My problem is:
1. If the student get a mark 49 below in any of their subject they will not be included in the ranking.


2. If all of the student mark is above 49, I need to rank the student base on their average.

I really need your help guys thank you very much...

[June7]

Review http://allenbrowne.com/ranking.html