Row Count of repeat fields

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a race results report that lists finishing times for team runners in
ascending order.
How can I count the repeat instances of a team name appearing, please?

eg name team time count
John Surrey AC 30:06 1
Fred Woking AC 32:10 1
Barry Surrey AC 33:14 2
Mark Surrey AC 33:20 3
Terry Woking AC 34:10 2

The Count function "=1" just increments for all records
 
This may be a case where you will need to do this in the underlying query.
You could add a calculated column as follows

Field: TeamPosition: (SELECT Count(Team) FROM YourTable as T WHERE T.Team =
YourTable.Team AND T.[Time] <= YourTable.[Time])

This can give you duplicates if two or more team members have the exact same
time
 
Back
Top