Allocating race result position

[timbl]

I am creating a DB for race results and have a field which calculates the elapsed time based on the start and finished times. What I want to do now is populate a field "position" with the finishing position relative to other competitors elapsed times in the race. But I cant see how to do this.
I have quite basic access skills!

I understand I would probab;y have to use some sort of query but not sure how to create it.

 

[Beetle]

Not sure if you're still in need of help on this, but...

I am creating a DB for race results and have a field which calculates the elapsed time based on the start and finished times.

I understand I would probaby have to use some sort of query..

A calculated field like you mentioned should be in a query to begin with. You can then sort the query on that field. If you need numbered rankings for each row, you may find this link helpful.

 

[timbl]

Thanks for the reply - but - sorry, too advanced for me!
To simplify things.
I have a table "Tblnames" with 3 fields "id", "name", "height".
I want to create a query which creates a field called "rank" which is a number which is the height order of people in my table.

Just want to know what code to use in my query.