[AccessD] Ranking rows

[Jim Lawrence]

Hi Gustav:

Very well done. Great piece of code. 

Jim

----- Original Message -----
From: "Gustav Brock" <gustav at cactus.dk>
To: "Access Developers discussion and problem solving" <accessd at databaseadvisors.com>
Sent: Friday, July 19, 2019 9:18:47 AM
Subject: [AccessD] Ranking rows

Hi all

Yet an article on row numbering, this time on how to rank rows:

https://www.experts-exchange.com/articles/33651/Ranking-rows-in-Microsoft-Access.html

<quote>
To rank something isn't that difficult. Basically, it is just to sort on the values to rank - points, goals, sales, citizens, whatever - in descending order or (typically for time) ascending order.
But how to rank dupes? Five methods exist, and they can all be implemented in pure SQL or using VBA.
</quote>

If you don't have an account, browse for the link: Read the full article.

Code is also on GitHub: https://github.com/GustavBrock/VBA.RowNumbers

/gustav

-- 
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com