Newbe off the the races

[Lefty]

Howdy:
Appreciate help in assigining a incrementing number. In a table with names and finish times as in a race, I will sort by time and then assign a sequential number to the name. Say Sue came in at 45:12, Bill came in at 47:15 and Mary came in last with a time of 49:00. After sorting by time I need to have Sue assigned a value of one, Bill assigned two and Mary a three. This data will be carried over to other tables from other days and added.


Thanks for any help

[SoftwareMatters]

You could create a new table based on your timing table that has an extra autonumber field. You could then copy and paste all the records from the original table to the new table.

OR, you could loop through the recordset and add/increment a value as you go.