Help with Ranking

[Mbithy]

I have a query with the following fields NAME ,TOTAL ,STREAM Elvis 439 East Yassin 500 North Titus 458 North Morgan 500 east I would like to rank name by total considering each stream.i.e in east morgan should be number 1

[recyan]

Till some one comes along, just check if below gives some guidelines :

http://allenbrowne.com/ranking.html

Thanks

[Mbithy]

I have a query with the following fields NAME ,TOTAL ,STREAM Elvis 439 East Yassin 500 North Titus 458 North Morgan 500 east I would like to rank name by total considering each stream.i.e in east morgan should be number 1

Thanks alot I got some guide lines

[recyan]

Thanks