Ranking records in a query

[sebbie10]

Pls someone to tell me how to rank the following using the Drank function in Ms access. i have generated the following query.

ADMNO NAMES STREAM mat eng kis phy chem bio cre his TTL AVG1
1231 Mutua E 45 67 89 67 78 89 67 56 558 50.7272727272727
1236 John E 45 67 89 90 56 60 67 56 530 48.1818181818182
1234 wendy W 34 56 78 90 67 89 45 45 504 45.8181818181818
1230 Njoka W 56 89 90 67 56 56 46 23 483 43.9090909090909
1232 Nelly E 34 56 78 90 43 67 45 45 458 41.6363636363636
1233 Felix W 34 56 67 89 90 34 45 23 438 39.8181818181818
1235 Rachael E 56 89 90 34 34 34 23 56 416 37.8181818181818
1237 Petre W 23 34 45 67 34 32 21 12 268 24.3636363636364

i will appreciate

 

[PHV]

using the Drank function in Ms access
What is this Drank function ?

Anyway, giving your sample data, what is the expected result ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886