HI i have a report that is based on a query with calculated fields this query/report shows 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 rank 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 linked to the query and if somone with low points suddenly has the most points it will then rank them as 1st 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.