If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Rank after Sort
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? -- Thanks for taking the time! CJ --------------------------------------------------------- Know thyself, know thy limits....know thy newsgroups! |
#2
|
|||
|
|||
Rank after Sort
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. -- KARL DEWEY Build a little - Test a little "CJ" wrote: 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? -- Thanks for taking the time! CJ --------------------------------------------------------- Know thyself, know thy limits....know thy newsgroups! |
Thread Tools | |
Display Modes | |
|
|