I am using MS Access 2000 to try and help me with my handicapping for horse racing - have been trying to win at the races for
the past 40 years - not successful yet - but I will never say die!! Think this must be easy but have spent days trying to
figure this out, still - with no success yet.
I have table with 4 fields ......"first", "second" and "third" and "number of horses".
Within each of the fields("first", 'second" and 'third") are numbers from 1 to 14 which show the final position that the
horse finished. The number of horses field is the number of horses in that race - i.e. - 5,6,7,8 etc.
I have been able to produce a report that displays a grouping by number of horses with individal results (first, second,
third) for each race. So far I have about 1300 individual race results. So I am trying to determine if any patterns exist by
number of horses.
So - does any one know how I can create a report....
First - by grouping - Number of Horses (5,6,7,8 etc) by their results and then being able to count the numbers of Final
positions - i.e. count the total numbers of 1's, 2's, 3's, 4's etc. for each field "First", "Second" and "Third".
Then - would it be possible to create a report by number of horses - that if the result of the Field "First" is 1 - then list
and count all the combinations of the "second" and "third" fields? Then if the result of Field "First" is 2 - then
combination s of "second" and "third" fields etc and so forth?
I can visualize what I am trying to accomplish but cant get it to work in Access - I may not find any patterns but at least I
am determined to try.
Thank you anyone who can provide some guidance. (Also - I am not too good in Access so if you wouldn't mind - plz advise
where for instance I should add a formula (should it go in Criteria in a query etc - or in a report - the type of box I would
need and where in a report - header footer etc)
Thank you very much - I appreciate any assistance - Steven