Here is an Access question for you.
Say I have a table of people’s weights and their names:
Joe 150
Pete 160
Dave 165
I can make a query than sorts in descending order:
Dave 165
Pete 160
Joe 150
No problem. But what if I want to assign a score based on weight. I.e. the highest weight gets the highest score. So, my output would be:...