1 Replies - 1242 Views - Last Post: 21 June 2013 - 11:01 PM Rate Topic: -----

#1 mutmalar  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 6
  • Joined: 17-June 13

Rank calculation

Posted 21 June 2013 - 09:28 PM

I have a database "student.mdb" having table "rank" with fields 1.regno(I) 2.Name© 3. Maths(I) 4.Physics(I) 5. Chemistry(I) 6. Total (I) 7. rank(I). I want put the rank in the rank field based on the Total field. suppose the student have secured same Total marks then i will give the first priority for highest mark secured in maths then Physics then Chemistry.

How to put the rank?
Is This A Good Question/Topic? 0
  • +

Replies To: Rank calculation

#2 vks.gautam1  Icon User is offline

  • D.I.C Regular

Reputation: 17
  • View blog
  • Posts: 317
  • Joined: 21-March 08

Re: Rank calculation

Posted 21 June 2013 - 11:01 PM

it is better to use sql statement.
select * from table order by total, maths,physics,chemstiry 


it's better you study sql to understand more about this. in this result will be displayed by total marks and after that scored marks in maths, phyiscs and so on.
http://www.w3schools...sql_orderby.asp
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1