how do I show the finishing position for each Team

June 11, 200322 yr

Newbies

I have a database that calculates team scores in a cross country running event.

Main fields: Name, Team Name, Place, Points (calc), Points Total (summary).

I can get a report that lists the team names and their Points Totals in order from highest to lowest (sorting by Team Name and Points Total).

My problem... simple as it sounds.. how do I show the finishing position for each Team in the summary?

1 Team C 1234

2 Team A 1123

3 Team C 1012

ie how do I get the 1, 2, 3 etc to list?

June 11, 200322 yr

Create a number field called "Place"

Sort the records by points as you already have worked out.

Run this script:

Go To Record/Request/Page [First]

Loop

. Set Field [Place, Status(CurrentRecordNumber)]

. Go To Record/Request/Page [Next][Exit After Last]

End Loop

If you want to be able to deal with tied placings, then its a bit more complicated. You will need to create some extra global fields where you store the points from the previous record and compare them to the current record. If they are the same - set the place as the same place as the previous record.