Arrange people in heats and finals

[Frank]

Is this Possible in a query?
Calculate_HeatsandLanes_Query: With fields
1. Race [Like 100m], 2. Name [Person], 3. Heat, 4. Final, 5. Lane

Each person has an enterytime when entered: [Entrytime]
Result of Query must look like this: [example]
Race Name Heat Final Lane
1 A 1 1
1 B 1 2
1 C 1 3
1 D 1 4
1 E 1 5
1 F 1 6
1 G 1 7

1 H 2 1
1 I 2 2
1 J 2 3
1 K 2 4
1 J 2 5

Race Name Heat Final Lane
2 A 1 1
2 B 1 2
2 C 1 3
2 D 1 4
2 E 1 5

Variables
The lanes available may vary from meet to meet thus there must be a choice
between 5 and up to 12 lanes depending on the event
The persons who enter a race may vary from 0 to 100
The heat are determined by the persons entered and the lanes available
If there are enough lanes per race for the persons who entered then the race
is a final
The order in which the persons are entered in a certain lane with each heat
or final is as follows: [example]
Fastest time heat 1 lane middle, 2nd fastest time heat 2 lane middle, 3rd
fastest time heat 3 lane middle[ect]
4th fastest time heat 1 lane to the left of the middle, 5th fastest time
heat two lane to the left of the middle, 6th fastest time heat 3 lane to the
left of the middle.
8th fastest time heat 1 lane to the right of the middle, 8th fastest time
heat 3 lane to the right of the middle, 19th fastest time heat 3 lane toe the
right of the middle ect. [This is an example for three heats. If there are
only two heats the same is applicable and when there are only a final the
same is also applicable

This query thus has to sort and order the Persons and Races for the whole
event and each one of the races

If this is possible it will make my day and lift the workload of organizing
a meet 100% and faster

 

[Tom van Stiphout]

On Wed, 6 May 2009 23:34:26 -0700, Frank

Given the multitude of business rules I would certainly implement this
in VBA with a DAO recordsets.

-Tom.
Microsoft Access MVP