HI i have a query that is based on calculated fields this query show me player averages and who has the most points.
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.