Function to Return Record Number in a Query

[Guest]

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

 

[Adrian Tofan]

This article should help you to solve your problem:
http://www.mvps.org/access/queries/qry0006.htm

 

[yenuka]

This article should help you to solve your problem:
http://www.mvps.org/access/queries/qry0006.htm