If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to get started with microsoft 2007 access
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 |
Thread Tools | |
Display Modes | |
|
|