Hi Davey,
Are you using 'RaceForm Interactive' ?
I produced a File Converter to change an EDECS file into
a Runners File and a Riders File back in Access95 days.
If you want to have fun and use Access to manipulate
the data then I will upload the File Converter to the
Access Files for you.
It may need tweaking if the EDECS format has changed
since I wrote it.
If you want make money instead then read Tom Segal
(PriceWise) in the Racing Post <g>.
Please let me know.
Regards, Clive(Williams)
--- In MS_Access_Professionals@yahoogroups.com, Crystal <strive4peace2008@...> wrote:
>
> Hi Davey,
>
> did this come from an XML dump? It appears to be structured. I see these tables ... and more ...
>
> Events
> - EventID, autonumber -- PK
> - EventName, text (ie: Saturday Races)
> - EventDate, date/time
>
> Courses
> - CourseID, autonumber, PK
> - CourseName
>
>
> Races
> - RaceID, autonumber, PK
> - RaceNo
> - CourseID
> - PrizeAmt
> - Winner
>
>
> Horses
> - HorseID, autonumber, PK
> - HorseName
> - hOwner
> - hDOB, date/time, date of birth
> - hAge, number, in case DOB is not available
> - hWeight, number
>
> - etc
>
> RaceHorses
> - RaceHorsID, autonumber, PK
> - RaceID, long, FK to Races
> - HorseID, long, FK to Horses
> - RunTime, date/time
>
> if prizes are trophies or something that revolves, you will need to put PrizeID in the Races table
>
> Prizes
> - PrizeID, autonumber, PK
> - PrizeName, text
> - PrizeAmt, currency
>
> PK = Primary Key
> FK = Foreign Key
>
> for structure ideas, watch the videos in the Learn Access playlist here:
> http://www.YouTube.com/LearnAccessByCrystal
>
> and read this book (especially Normalization and Relationships chapters)
>
>
> Access Basics by Crystal (Bill Mosca's site)
> http://thatlldoit.com
> Free 100-page book that covers essentials in Access
>
> and get a couple good big reference books for Access such as a book in John Viescas' signature ;)
>
> Warm Regards,
> Crystal
>
> *
> (: have an awesome day :)
> *
>
>
>
>
>
> ________________________________
> From: John Viescas
>
> Davey-
>
> Well, the data you pasted is almost impossible to read! If you have a table for
> horses, then put the linking HorseID into the Results table to link the result
> to the horse. In an Access form, you would use a combo box on HorseID in the
> results form to pull in the horse names to make it easy to pick the right ID.
>
> John Viescas, author
> Microsoft Office Access 2010 Inside Out
> Microsoft Office Access 2007 Inside Out
> Building Microsoft Access Applications
> Microsoft Office Access 2003 Inside Out
> SQL Queries for Mere Mortals
> http://www.viescas.com/
> (Paris, France)
>
>
>
> -----Original Message-----
> From: Davey H
> Sent: Tuesday, October 25, 2011 s
>
> Even though I'm the wrong side of Cemetary Hill I joined the computer
> revolution and taught myself Excel.
> My hobby is Horse Racing and I had been keeping the results in an Excel
> File. However that has grown to a huge spreadsheet and I found it very
> hard to learn how to extract the information needed.
> I therefore tried to learn Access but am finding it very difficult to
> understand in places in particular keys and relationships. Below are the
> tables. the HORSE table has ID as primary key but after that I'm at a
> loss trying to decide primary and foreign key connections between
> tables.
> I would appreciate your advice.
>
> Many Thanks
> Davey H
>
> RESULTS DECS HORSE
> RaceNo 466066 466080 RaceNo 1
> HORSEID HORSE Course DONC NEWB Course
> ASCO 1 A B Celebration Date 21-Oct-11
> 21-Oct-11 Date 1/1/2011 2 A Boy
> Named Suzi Rtime 15:45 16:05 Rtime 14:00
> 3 A P Ling Go GD GF Go GD
> 4 A Pocketful Of Rye (IRE) Age 4 4 Furs
> 6 5 A Southside Boy (GER) Furs 6 10
> Class 4 Class 2 4
> Prize 1111 Prize £11,450
> £4,528 Horse A P Ling
> Ran 22 15 Pos
> 1 1 Drw 20
> 14 RACES Btn 2.25
> 0.1 RaceNo 466066 466080 466067 466081
> 466068 TBtn 2.25 0.1 Course DONC
> NEWB DONC NEWB DONC Horse Bohemian Melody
> Jiwen (CAN) Date 21-Oct-11 21-Oct-11 21-Oct-11
> 21-Oct-11 21-Oct-11 Wgt 122 129
> Rtime 15:45 16:05 16:20 16:40 16:55 OR 91 83
> Go GD GF GD GF GD GRD 105 81
> Age 4 4 4 3 4 WA 4 8 Furs
> 6 10 14.6 8 10.3 AA 0 0
> Class 2 4 4 5 4 PPL 2.95 1.77
> Prize £11,450 £4,528 £4,528 £2,588 £4,528
> RAW 102 85 Ran 22 15 18 12 19
> RAWadj 88 82 BHB 105 81 84 75 85
> BHB 107 81 WA 4 8 0 9 7
> BHBadj 89 70 AA 0 0 0 2 0
> HEAL 98 78
> ORADJ 80 72
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar