I have a table name "Masterstudent.dbf" with fields 1. regno 2. DOB 3. category 4. Mathsmax 5. mathssec 6.Physicsmax 7.physicssec 8. chemistymax 9. chemistrysec 10. Total marks 11.rank

The Maximum marks of each subjects is 200. i put the total marks for each student using formula - (mathssec+physicssec+chemistrysec)/3.

Example
mathssec = 185, Physicssec = 190, Chemistrysec = 192 Total marks = 189

mathssec = 195, Physicssec = 185, Chemistrysec = 187 Total marks = 189


When more than one student have got same total marks, the inter-Se merit among each student will be determine the order of priority as given below

1. student got Highest marks in Mathssec

2. student got Highest marks in physicssec

3. student got Highest marks in chemistrysec

4. Student DOB

How to put the rank for each student?