Thank you!
I have now put it into my database, but I get this message: "Undefined function getRanking in the expression"!!
SELECT Kl1Lær1.Navn, Kl1Lær1.Speilnr, Kl1Lær1.Dommer1kl1, Kl1Lær1.Dommer2kl1, Kl1Lær1.Dommer3kl1, Kl1Lær1.Sum, getRanking([Sum],"Descending") AS Ranking
FROM Kl1Lær1
ORDER BY Kl1Lær1.Sum DESC;