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.
It’s a great opportunity to get up to speed with the latest Microsoft Access technology.
Get real world tips about how to get the most out of Access and VBA.
Meet and network with international fellow Access developers!