Forum Discussion
Ordinal Rank in Query
Greetings:) I am struggling with a query that will rank the 1st time a specific "award" is earned, 2nd time, and third or more times. I am an Access novice and can't quite figure it out. I'd like to...
You might also be able to adapt the approach Allen Browne describes here for ranking and numbering records. It's not precisely the same task, but close enough for you to get a few ideas about how to modify it to suit your design.
Thank you, I will look at this link! -DEB
I use a different approach to ranking using a Serialize function.
See my article: https://www.isladogs.co.uk/rank-order-queries/index.html- I will see what I can do to figure this out. Thank you! -DEB
