Quote:
> a ski race asociation has the fastest racer run number 5 in the next
> race. looks kike this.
> no. 1 - races no. 5
> 2 4
> 3 3
> 4 2
> 5 1
> from 6 on everyone races in order of last race finish.
> any ideas on how to code a sort of records based on the time number
> field to reflect this order.
> thanks - crazy in milwaukee
If [Previous Finish Position] < 6 Then
Select Case [Previous Finish Position]
Case 5
[Starting Position] = 1
Case 4
[Starting Position] = 2
....
End Select
Else
[Starting Position] = [Previous Finish Position]
End If
You could spend some time and work out an algorithm to calculate the
[Starting Position] from the [Previous Finish Position] and eliminate
the Select Case... stuff, but there are only 5 cases to worry about, and
the debugging is easier....
HTH,
--
National Library of Canada
Anti spam note: Do not Reply without correcting the address
** None of the above has any official status **
1 is 5 in record order