Hi Davey,
Did you see my message 93900?
If you upload a recent EDECS file I will test my
old code to see if it runs OK with latest level.
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, "Clive" <zctek@...> wrote:
>
> 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