How to Rank records in a Crosstab query?

[titanl]

Hi,
I need to rank records in a Crosstab query based on a select query name qryRanking_CategoryU16 as follows:

Column1; Field: Category, Table: qryRanking_CategoryU16, Total: Group By, Crosstab: Row Heading
Column2; Field: SchoolName, Table: qryRanking_CategoryU16, Total: Group By, Crosstab: Row Heading
Column3; Field: SchoolName, Table: qryRanking_CategoryU16, Total: Group By, Crosstab: Column Heading
Column4; Field: Points, Table: qryRanking_CategoryU16, Total: Sum, Crosstab: Value
Column5; Field: TotalOfPointsoints, Table: qryRanking_CategoryU16, Total: Sum, Crosstab: Row Heading

The crosstab query actually calculate points score by athletes from different schools participating in several races and the points are added together to determined the schools with the highest points. (Altogether there are about 28 schools)

Thanks for the help.

titanl