I'm trying to use access to prepare for a swimming race.
I want the report to show who got which lane.
This is how it works.
if we have 8 swimmer or less
then this is how it pick the position
name Speed
A 30Sec
B 31Sec
C 33Sec
D 36Sec
E 38Sec
F 39Sec
G 41Sec
H 44Sec
Position Chart
Lane
1 G
2 E
3 C
4 A
5 B
6 D
7 F
8 H
But if Swimmer is greater than 8, then it will divided in to 2 groups, forming a V Shape like this
Position Chart for Greater than 8 but not more than 16
Group 2
Lane
1 N
2 J
3 F
4 B
5 D
6 H
7 L
8 P
Group 1
Lane
1 M
2 I
3 E
4 A
5 C
6 G
7 K
8 O
Where do I get this position?
It's like this
Lane 1 2 3 4 5 6 7 8
Group1 14 10 06 02 04 08 12 16
Group2 13 09 05 01 03 07 11 15
The question is, how can I create a report which I can set the location of each data? or any easier way to do it?