Adding positions to query sort results 1

[TrekBiker]

I'd like to be able to assign positions to the results of a query sorting teams' scores by points, like this

Team / Points / Position
D / 825 / 1
C / 795 / 2
B / 775 / 3
A / 765 / 4

Is this possible?

 

[MajP]

Google "ranking queries" and you will get a lot of examples of ways to do this. Here is one

http://bytes.com/topic/access/insights/954764-ranking-queries-ms-access-sql

 

[TrekBiker]

Thanks MajP, this looks to do the job. Will experiment.