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?
eg
1 Team C 1234
2 Team A 1123
3 Team C 1012
ie how do I get the 1, 2, 3 etc to list?