Ranking in Access database

[Tadele]

I want your support on how to rank students in Access database

 

[plog]

Not only do I support you on doing this, I will even help by answering specific questions you have.

 

[Tadele]

Thanks,
I wolud like to get a formula or criteria to rank students achievement in a class like what ranking do in excel
. Could you help ?

 

[plog]

Sure, can you post some sample data from your table (include field and table names) and then what the resulting data should be based on the starting data. Use this format for posting:

TableNameHere
Field1Name, Field2Name, Field3Name
Amy, 92, 4/16/2008
Sally, 88, 5/4/2009
Tim, 97, 6/6/2003