Hi,

I'd like to produce a report which has a top ten list of names across a series of scores. For instance, column 1 is the ranking, the top ten people in English as column 2, top ten in Maths as column 3 etc.

The data is in a simple format though, with separate column scores for each subject.

What's the best approach?

Thanks,
Antro.

Create a crosstab query and use this as the source for your report. The ROW will be your ranking and the COLUMN will be your subject.

Stopher

Thanks Stopher,

But for a crosstab, I'd need the rank as a column for each subject right? Then I could do the crosstab as you suggest. But what if I don't have the ranks, just the scores? Do I need to do four queries to rank the scores, then run a crosstab which powers the report?

My Table is just:

id Name MathScore EnglishScore ScienceScore
1 Antro 50 50 50
2 Stopher 55 45 50
...

Thanks for your time,
Antro.