R
Richard Mac
I have an excel worksheet on horse racing and I wish to use access? or
something to read the data, see if a horse matches the criteria and write a
report that says "this one" The data to be access is as below; This has not
come out in its true excel columns, nor do I know how to do that. So this
dummy needs big help.
So if anyone reads this perhaps I may be able to explain the data somehow.
Date 16/03/2008 at 3:25 BALLINA DEAD track race no. 6 distance
1300m class RB62 BS RATE
46
F5 BAR age cls LS BR rate spd rate time spd rate sec Win
% DAYS DAYS DAYS 1st up 50,80 2nd up 33,80 3rd up 33,80 API Wgt CH DIST
CH at dist 15.50 at track 15,40 track cond. 0,40 3LS MARG 2LS MARG LR
MARG 3LS PAR TIME 3LS SECT TIME 2LS PAR TIME 2LS SECT TIME LR PAR TIME LR
SECT TIME 3LS TIME RAN 3LS SECT RAN 2LS TIME RAN 2LS SECT RAN LS TIME RAN LS
SECT RAN TIME 3 SECT 3 TIME 2 SECT 2 TIME LR SECT LR 2LS BEST TIME LS BEST
TIME
1 8 5 RB72
100 99 17 10 19 14 0,0 1 6 100 0,25 0,16 25,50 3.8 10.2 0 69.65 34.86 73.26 36.09 70.31 34.9 69.93 34.97 73.26 36.09 70.31 34.9 1
2 14 8 RB67
105 7 14 37 6 25,62 1.5 2 100 15,52 9,36 7,38 5 1.6 2.5 83.7 83.76 35.2 71.74 36.42 83.9 83.76 35.2 71.74 36.42 2
3 6 4 RB67
88 77 18 279 53 6 25,50 1.2 1 100 100,100 50,75 0,50 10.9 2.8 9.4 70.63 35.29 65.8 36.35 71.74 36.42 70.21 34.27 65.8 36.35 71.74 36.42 3
4 2 3 Mdn
77 33 16 19 14 0,0 2 0 -216 0,0 5.6 4.1 0 60.73 36.2 73.99 38.02 94.38 37.52 59 36.2 74.72 38.53 94.5 36.4 4 5.18 4.57
5 9 7 Cls1
65 98 7 11 15 16 0,33 0.7 1 -50 0,40 0,33 3.3 1.5 3.5 76.36 37.36 83.13 36.9 83.6 36.96 74.24 35.72 84.15 36.86 83.18 36.46 5 4.13 3.16
6 4 4 RB62
2 11 196 19 14 0,66 1.4 -1 -216 0,100 0,33 100,100 6.1 5.5 7 120.26 37.18 73.26 36.09 92.69 37.05 120.26 37.18 73.26 36.09 92.3 36.4 6 0
7 1 5 RB60
78 105 13 30 12 63 0,0 0.8 1 -118 0,50 0,50 0,0 6.7 6.8 0 85.14 36.32 72.5 37.55 89 41.2 85.05 36.35 72.1 37.3 89.4 41.2 7 0 0.8
8 5 5 Mdn
88 88 3 21 14 8 0,25 0.3 -3 100 0,0 0,0 3.8 0.5 0 55.82 71.95 71.68 55.45 71.16 72.5 8 0.72 1.86
9 11 9 RB62
65 105 12 21 16 6 10,20 1.9 -1 -100 10,20 12,25 15,23 8.8 5.9 8.2 95.99 35.59 103.38 35.18 85.08 36 96.45 35 103.38 35.18 85.08 36 9
10 10 4 RB62
111 125 11 10 11 22 0,50 0.6 0 100 0,33 6.9 0 10.1 65 35.4 73.99 38.02 69.65 34.86 62.82 34 75.14 38.71 68.73 34.24 10 5.6 0
11 3 6 RB62
102 96 8 6 45 14 0,0 0.8 0 300 0,16 0,0 25,50 1.3 2.4 2.1 73.33 36.02 71.75 36.69 58.75 34.78 73.25 35.94 72.12 36.83 59.6 36 11 0.73 1.7
12 13 5 RB62
109 87 3 35 8 6 0,25 0.9 0 -100 14,57 0,25 0,14 4.8 10.5 5.3 99.6 38.57 92.69 37.05 85.08 36 99.6 38.57 92.3 36.4 85.08 36 12 0
13 7 4 RB62
88 108 4 17 50 14 0,0 0.2 0 -216 25,25 11,22 0,18 4.7 0 20.8 58.76 35.46 81.78 37.77 92.69 37.05 58.66 35.24 81.84 37.06 92.3 36.4 13 4.14 0
14 12 4 RB60
96 66 4 12 55 8 0,50 0.7 0 -70 25,50 0,40 20,60 4.7 2.6 7.4 72.5 37.55 89 41.2 83.41 35.88 72.1 37.3 88.6 41.2 83.41 35.88 14 0
15 scr 15
16 scr 16
17 17
18 18
19 19
20 20
21 21
22 22
23 23
24 24
something to read the data, see if a horse matches the criteria and write a
report that says "this one" The data to be access is as below; This has not
come out in its true excel columns, nor do I know how to do that. So this
dummy needs big help.
So if anyone reads this perhaps I may be able to explain the data somehow.
Date 16/03/2008 at 3:25 BALLINA DEAD track race no. 6 distance
1300m class RB62 BS RATE
46
F5 BAR age cls LS BR rate spd rate time spd rate sec Win
% DAYS DAYS DAYS 1st up 50,80 2nd up 33,80 3rd up 33,80 API Wgt CH DIST
CH at dist 15.50 at track 15,40 track cond. 0,40 3LS MARG 2LS MARG LR
MARG 3LS PAR TIME 3LS SECT TIME 2LS PAR TIME 2LS SECT TIME LR PAR TIME LR
SECT TIME 3LS TIME RAN 3LS SECT RAN 2LS TIME RAN 2LS SECT RAN LS TIME RAN LS
SECT RAN TIME 3 SECT 3 TIME 2 SECT 2 TIME LR SECT LR 2LS BEST TIME LS BEST
TIME
1 8 5 RB72
100 99 17 10 19 14 0,0 1 6 100 0,25 0,16 25,50 3.8 10.2 0 69.65 34.86 73.26 36.09 70.31 34.9 69.93 34.97 73.26 36.09 70.31 34.9 1
2 14 8 RB67
105 7 14 37 6 25,62 1.5 2 100 15,52 9,36 7,38 5 1.6 2.5 83.7 83.76 35.2 71.74 36.42 83.9 83.76 35.2 71.74 36.42 2
3 6 4 RB67
88 77 18 279 53 6 25,50 1.2 1 100 100,100 50,75 0,50 10.9 2.8 9.4 70.63 35.29 65.8 36.35 71.74 36.42 70.21 34.27 65.8 36.35 71.74 36.42 3
4 2 3 Mdn
77 33 16 19 14 0,0 2 0 -216 0,0 5.6 4.1 0 60.73 36.2 73.99 38.02 94.38 37.52 59 36.2 74.72 38.53 94.5 36.4 4 5.18 4.57
5 9 7 Cls1
65 98 7 11 15 16 0,33 0.7 1 -50 0,40 0,33 3.3 1.5 3.5 76.36 37.36 83.13 36.9 83.6 36.96 74.24 35.72 84.15 36.86 83.18 36.46 5 4.13 3.16
6 4 4 RB62
2 11 196 19 14 0,66 1.4 -1 -216 0,100 0,33 100,100 6.1 5.5 7 120.26 37.18 73.26 36.09 92.69 37.05 120.26 37.18 73.26 36.09 92.3 36.4 6 0
7 1 5 RB60
78 105 13 30 12 63 0,0 0.8 1 -118 0,50 0,50 0,0 6.7 6.8 0 85.14 36.32 72.5 37.55 89 41.2 85.05 36.35 72.1 37.3 89.4 41.2 7 0 0.8
8 5 5 Mdn
88 88 3 21 14 8 0,25 0.3 -3 100 0,0 0,0 3.8 0.5 0 55.82 71.95 71.68 55.45 71.16 72.5 8 0.72 1.86
9 11 9 RB62
65 105 12 21 16 6 10,20 1.9 -1 -100 10,20 12,25 15,23 8.8 5.9 8.2 95.99 35.59 103.38 35.18 85.08 36 96.45 35 103.38 35.18 85.08 36 9
10 10 4 RB62
111 125 11 10 11 22 0,50 0.6 0 100 0,33 6.9 0 10.1 65 35.4 73.99 38.02 69.65 34.86 62.82 34 75.14 38.71 68.73 34.24 10 5.6 0
11 3 6 RB62
102 96 8 6 45 14 0,0 0.8 0 300 0,16 0,0 25,50 1.3 2.4 2.1 73.33 36.02 71.75 36.69 58.75 34.78 73.25 35.94 72.12 36.83 59.6 36 11 0.73 1.7
12 13 5 RB62
109 87 3 35 8 6 0,25 0.9 0 -100 14,57 0,25 0,14 4.8 10.5 5.3 99.6 38.57 92.69 37.05 85.08 36 99.6 38.57 92.3 36.4 85.08 36 12 0
13 7 4 RB62
88 108 4 17 50 14 0,0 0.2 0 -216 25,25 11,22 0,18 4.7 0 20.8 58.76 35.46 81.78 37.77 92.69 37.05 58.66 35.24 81.84 37.06 92.3 36.4 13 4.14 0
14 12 4 RB60
96 66 4 12 55 8 0,50 0.7 0 -70 25,50 0,40 20,60 4.7 2.6 7.4 72.5 37.55 89 41.2 83.41 35.88 72.1 37.3 88.6 41.2 83.41 35.88 14 0
15 scr 15
16 scr 16
17 17
18 18
19 19
20 20
21 21
22 22
23 23
24 24