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

Nigel wrote:

>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.

--
Marsh
MVP [MS Access]

Try Stephen Lebans' RowNumber:

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

--
HTH
Van T. Dinh
MVP (Access)



"Nigel" <(E-Mail Removed)> wrote in message
news:134B38FC-F82C-4885-A3FE-(E-Mail Removed)...
>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

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

"Van T. Dinh" wrote:

> Try Stephen Lebans' RowNumber:
>
> http://www.lebans.com/rownumber.htm
>
> --
> HTH
> Van T. Dinh
> MVP (Access)
>
>
>
> "Nigel" <(E-Mail Removed)> wrote in message
> news:134B38FC-F82C-4885-A3FE-(E-Mail Removed)...
> >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
>
>
>