10th March 2005, 06:50 PM
|
|
Member
|
|
Join Date: Jan 1970
Posts: 4,415
|
|
Duritz,
Attached are two excel files:
One for Horse.xls (contains the Horse history and additional comments which should be imported to the access table Horse.dbf)
One for Race.xls (contains the raceday information which should be imported to the access table Race.dbf)
One Access file:
Has a query built which pulls the information for today's race AND comments about the horse's last run etc.
You can add, delete or rename fields in the spreadsheets accordng to your requirements, but you must then modify the table field names and the corresponding query.
It's not perfect as I'm flatout and did it in a hurry, but it will get you started as an example anyway.
|