Numbering Groups in Access Reports

[MCAUK]

Hi everybody,

I have a report feeding from a table. The aim of the report is to list projects by priority position based on a score number assigned earlier through formula.

The report has tehrefore a [totalscore] field. There may be projets with the same total score.

I need to group projects by score (no problem there) but then I need to number the groups rather tha the records. I am currently usinfg a textbox control holding the formula [=1]. The problem is that it assigns a number to each record rather than each group

The ultimate aim of this is that the Group number is taken as the priority position for the projects:-

CURRENTLY:

[=1] Score Name of project
1 85 Project 1
2 79 Project 2
3 79 Project 3
4 60 Project 4


Shoudl be:-

[=1] Score Name of project
1 85 Project 1
2 79 Project 2
79 Project 3
3 60 Project 4

Any suggestions most appreciated.

Thanks

MCAUK