Automatically assign Ranking based on Time taken

[Guest]

I have a form where a time is entered in seconds in each row ie 103.36 102.23
etc. Also in that form I have a position filed, what I am trying to do is for
some code to scroll thru the form and assign a ranking to each record based
on the number of seconds. Ie the lowest would be 1 and so on. Does anyone
have any idea how this would be done

Thanks

 

[Marshall Barton]

I have a form where a time is entered in seconds in each row ie 103.36 102.23
etc. Also in that form I have a position filed, what I am trying to do is for
some code to scroll thru the form and assign a ranking to each record based
on the number of seconds. Ie the lowest would be 1 and so on. Does anyone
have any idea how this would be done

This is relatively easy to do using a query with a subquery:

SELECT T.person,
(SELECT Count(*)
FROM thetable As X
WHERE X.seconds <= T.seconds
) As Position
FROM thetable As T

But it would take a sort algorithm operating on the form's
recordset to do it in code. If you use a query like the
above as the form's record source, then the only code you
would need is
Me.Requery
whenever you want to display the new positions after
entering/editing some time values.

 

[Van T. Dinh]

Try Stephen Lebans' RowNumber:

http://www.lebans.com/rownumber.htm

 

[Guest]

OK I am halfway there

I have the record number now I need to be able to click an button on the
form and have it loop thru each record on the form and place the value from a
field called rownum into a field called position. Once it reaches the last
record stop