[AccessD] Ranking rows

[jack drawbridge]

Ditto to Jim's comment. Thanks for sharing Gustav.

On Fri, Jul 19, 2019 at 4:05 PM Jim Lawrence <accessd at shaw.ca> wrote:

> 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
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>