import time

[mdb231]

Hi all
Is there any way I can import a time for a specific race at a course.
what I need to do is something like,if horse has won a race in a certain time, I would like to put another time in next column from a batabase this i would like to do for every race on each day for all courses which is a lot of time,the other time is the par for that distance.
Thanks in advance
Michael

 

[mdb231]

A B C D E F G H
Salisbury Flat Thursday 11-Aug-11 14:00 Good to Firm 1m28.98s
Salisbury Flat Thursday 11-Aug-11 14:30 Good to Firm 1m28.67s
Salisbury Flat Thursday 11-Aug-11 15:05 Good to Firm 1m28.74s
Salisbury Flat Thursday 11-Aug-11 15:40 Good to Firm 2m35.46s
Salisbury Flat Thursday 11-Aug-11 16:15 Good to Firm 1m41.01s
Salisbury Flat Thursday 11-Aug-11 16:50 Good to Firm 1m15.23s
Salisbury Flat Thursday 11-Aug-11 17:20 Good to Firm 3m06.13s
Newmarket Flat Thursday 11-Aug-11 14:20 Good to Firm 1m13.44s
Newmarket Flat Thursday 11-Aug-11 14:50 Good to Firm 2m06.19s
Newmarket Flat Thursday 11-Aug-11 15:25 Good to Firm 1m25.55s
Newmarket Flat Thursday 11-Aug-11 16:00 Good to Firm 1m25.49s
Newmarket Flat Thursday 11-Aug-11 16:35 Good to Firm 1m25.39s
Newmarket Flat Thursday 11-Aug-11 17:10 Good 2m36.76s
Newmarket Flat Thursday 11-Aug-11 17:45 Good 0m59.13s
Beverley Flat Thursday 11-Aug-11 14:10 Soft Heavy in places 1m06.99s
Beverley Flat Thursday 11-Aug-11 14:40 Soft Heavy in places 3m50.47s
Beverley Flat Thursday 11-Aug-11 15:15 Soft Heavy in places 1m05.37s
Beverley Flat Thursday 11-Aug-11 15:50 Soft Heavy in places 1m41.32s
Beverley Flat Thursday 11-Aug-11 16:25 Soft Heavy in places 2m49.4s
Beverley Flat Thursday 11-Aug-11 17:00 Soft Heavy in places 1m55.76s
Beverley Flat Thursday 11-Aug-11 17:30 Soft Heavy in places 1m56.96s
Goodwood Flat Thursday 11-Aug-11 16:55 Good Good to Firm in places 1m12.96s
Goodwood Flat Thursday 11-Aug-11 17:30 Good Good to Firm in places 0m59.87s
Goodwood Flat Thursday 11-Aug-11 18:00 Good Good to Firm in places 2m11.17s
Goodwood Flat Thursday 11-Aug-11 18:30 Good Good to Firm in places 2m35.95s
Goodwood Flat Thursday 11-Aug-11 19:05 Good Good to Firm in places 1m39.66s
Goodwood Flat Thursday 11-Aug-11 19:40 Good Good to Firm in places 2m07.69s
Goodwood Flat Thursday 11-Aug-11 20:10 Good Good to Firm in places 1m11.87s
Chepstow Flat Thursday 11-Aug-11 17:15 Good 1m01.6s
Chepstow Flat Thursday 11-Aug-11 17:50 Good 1m37.42s
Chepstow Flat Thursday 11-Aug-11 18:20 Good 1m36.67s
Chepstow Flat Thursday 11-Aug-11 18:50 Good 1m13.16s
Chepstow Flat Thursday 11-Aug-11 19:25 Good 4m05.52s
Chepstow Flat Thursday 11-Aug-11 20:00 Good 2m40.43s
Chepstow Flat Thursday 11-Aug-11 20:30 Good 2m12.49s

This is what I mean, column G will have the winners time, but in H it will have the par time for the course and distance from another database,like if A AND L = CHEPSTOW 7F THEN GOTO OTHER DATA BASE AND PRINT in column H whatever the time for that course and that distance hope this helps.