:confused: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