Ranking Students based on Score & Location and selecting Top three...

[dolovenature]

Hi,

As a Novice i need to require your help with following subjects...

I am having a FORM(form1) based on TABLE(table1) with some text box & combo box & command buttons.

One field is score which calculate the percentage of marks based on three subjects of the students.

Another field is LOCATION.

My problem is.....



1) I need to Rank the Top Three students based on the SCORE field for each particular location.
(if location is X then need to rank students under this location) and similar for location Y and so on....

2)Need to select top ranked Three students from each location.

3) After this selection, the remaining students need to be ranked as a whole.

How to solve this problem???

Regards

Saikat

[orange]

Show us your Tables and relationships.

[dolovenature]

Show us your Tables and relationships.

Actually I am having only ONE Table as Table1 with 5 Text Box, ( Name, Addr, Age, Sex, father's name), One Combo ( Location), And Three Text box for marks in three different subject and one "Score" field which is calculating % of marks.

Now i need the students ranked based on % of marks and locality and need to select TOP three students from each location.

The remaining students need to be ranked as a whole.

Waiting egarly for solutions.

Thanks
Regards'
saikat

[orange]

And where exactly will you store the 3 marks for 3 separate subjects and Locations.

Before we can help you get a "solution", you have to identify and design all aspects of your "issue/problem/opportunity".

I am attaching a link to an Entity Relationship Diagramming tutorial. I suggest you read it thoroughly, then use it with your data to create a proper set of Tables and Relationships that support your "business".

http://www.rogersaccesslibrary.com/T...lationship.zip

Good luck with your project.

[June7]

Review http://allenbrowne.com/subquery-01.html
Look at example: Top n records per group

Also, http://allenbrowne.com/ranking.html