Rank after Sort

[CJ]

Hi Groupies:

I am creating a database for a golf tournament. After the Thursday and
Friday scores are input, I need to flight the players for Saturday.
I have a query that correctly sorts the players based on their scores and
tie breakers (sorting based on all 18 holes).
So, now I have a list of 288 golfers but I need to be able to sequentially
number their record from 1 - 288.
I have tried some of the suggestions for ranking from this newsgroup but it
always compares a total. I can not use this
because there are frequently tie scores, thus the need for tie breakers.

Is there a way to just add a column to my query that will start with the
person at the top and number down from 1 - 288?

 

[KARL DEWEY]

In design view of your report do the following --
In the Navigation Pane, right-click the report and then click Design View
on the shortcut menu.
On the Design tab, in the Controls group, click Text Box.
In the Detail section of the report, drag the pointer to create the text
box, making sure that it's wide enough to accommodate the largest item number.
For example, if you will likely have one hundred orders, you will need space
for at least three characters (100). If a label appears next to the text box,
delete the label by clicking it and then pressing DELETE. If you placed the
text box near the left margin, the label might be hidden under the text box.
Using the move handle on the upper left corner of the text box, drag the text
box to the right so that you can see the label. Then, you can click the label
and press DELETE.

Select the text box. If the property sheet is not already displayed, press
F4 to display it.
Click the All tab. In the Name property box, type a name, such as
txtItemNumber.
Click the Data tab.
In the Running Sum property box, select Over Group.
In the Control Source property box, type =1.
Click the Format tab.
In the Format property box, type #. (a pound sign followed by a period).
This formats the line number with a period following the number.

Save the report and switch to Report view to see the results.

Taken from the help.