How can I calculate(update) a soccer league table in access 2019?

[GratianMoise]

I want to learn how to solve this request, in a microsoft access 2019 database:
"The classification field will be filled in according to the following reasoning: all the points obtained by a team are added and depending on the reverse order of the ranking, the field place_classification is also updated!"
I don't know how to calculate the request:
for example: If Real Madrid has 100 points then results in the field place_classification = 1st place;
If Barcelona has 99 points then results in the field place_classification = 2nd place....and just like that for the rest of the teams created by me from my database leaderboard.
If anyone could help me with a hint or a solution I will appreciate it.
Thank You.

[orange]

Review this material.

[ranman256]

one way is to have a 'report' table that has an autonum field PLACE.
sort your data on POINTS field then append the data to this report table
since the highest points get added 1st then the autonum will assign 1 .
then next will get 2, and so on.

Note: this works the 1st time only
so if you need to erase the data and re-use this report table ,you must reset the autonum to 1 by empting the data, then compact the db.
otherwise erasing the data and adding more data will just continue to add to the autonum where it left off, Not 1.

[GratianMoise]

Thank you for the help, I will try this and I'll return with a response.

[Welshgasman]

I would have thought you would just add records with the points for each team.?

Then run a query to sum the points and display in descending order of the sum of points?