Hi Davey,
The file that you showed in your first post looked like
it could have come from an EDECS file. An EDECS file
contains all the information about races, runners and
riders. They are produced and updated before and on race
days in the UK and Ireland.
Raceform Interactive, http://www.raceform.co.uk
is one of the providers of horse racing information. It is
not cheap unless you are a banker. There was a special
offer of £150 for 4 months back in 2007,
see: http://www.olbg.com/forum/topic6_15438.html
so it must cost about £50 a month by now. I suppose that's
a lot cheaper then a pint of beer a day. Yes, I just
found a link: https://www.racingpost.com/bookshop/
My philosophy on gambling is "Don't spend money on it
that you could not afford to flush down the loo!" but
if it is a pastime that grips you, limit your outgoings
to a definite amount and if you are on a 'winning streak'
don't be tempted to increase the amount. That's due to
my mathematical background. (end-of-sermon)
Q1. Where did you get hold of the data that you showed us?
Q3. Can you upload a file to the Group Files Folder:
2_AssistanceNeeded? (nothing confidential and also
zipped to save space)
Q2. What information do you want to extract from the data?
e.g. Races, Runners, Riders, PrizeMoney etc.
Hope that helps.
Regards, Clive.
--- 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