HI i have a query that is based on calculated fields this query show me player averages and who has the most points.

Exampke below

Player name Total won Lost Played for against +/_ Total Points

what I want the query to do is rant the points in order of highest first i think dcount would do this but do not know how to write the expression.

So basicaly every time the data has been edited via a form i then click on the report which is liked to the query and if somone with low points suddenly has the most points it will then rank them as f1st etc

The table that i use for the query were players for player name
and Sunday match data that the quey calculates the totals from.