[AccessD] Ranking rows

fhtapia at gmail.com fhtapia at gmail.com
Tue Jul 23 07:35:24 CDT 2019


Kudos

On Fri, Jul 19, 2019 at 1:45 PM jack drawbridge <jackandpat.d at gmail.com>
wrote:

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


More information about the AccessD mailing list