Function to Return Record Number in a Query

D

Dexter Crawford

I am working on a database for my school, and want to calculate a student's
place in the class (1st, 9th, etc.) based on his/her total marks. I can sort
the query based on the total marks attained, but am looking for a function
similar to the Count(*) function that will return the record number of that
number in a query. Is there such a function? Or is there another way to
calculate and display this value?
Thanks
 
Top