I want to convert my racing spreadsheets into an Access database and am trying to teach myself Access using the help files.

One thing I will need to do is rank each horse's rating within a race. The table will consist of multiple races and there is a record for each horse - one of the records is a rating. Using a query, how do I add a field with the ranking?

The table has a field called RaceID which identifies one race from another in the table. Of course, the number of horses in each race can vary.

Any help would be much appreciated.