I've uploaded a rar file called ML28-oct to the file section. I do a
little bit of adjustment to get it how I want it.
I then import it into Access. Eventually I want to pull the last 3 runs
for each runner and display them in order from the results file.
Davey H
--- In MS_Access_Professionals@yahoogroups.com, "Davey H"
<lansdowne05@...> wrote:
>
> Sorry for the delay in replying.
>
> Firstly I am not using Raceform Interactive, and secondly much to my
> embarrassment I have none the wiser what an
> EDECS file is despite googling it. I'm afraid my knowledge isn't that
> great.
> I'd be grateful if you could explain what it is
>
> Davey H
>
>
> --- In MS_Access_Professionals@yahoogroups.com, "Clive" zctek@
> wrote:
> >
> > 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