Search results

Continuing saga of my horse racing project. I am using Access 2010 and Excel 2010. I have attached a small database with a table and 2 queries. 'Table1' has the following fields: MtgDate, Race, Margin (in metres), Rate For each Race I want to get the average Rate for Top 6 Horses that finish...

Yes you are right. I have gone back over my data and K122 being the Brand for the Horse will be unique. I think I have to simplify my approach.

Sorry. been away for a week. Yes I think that may be the way to go. I am still getting my head around this task. I have mocked up a small Excel pivot table with 4 horses over 5 races. It takes approx 25 iterations to almost converge. I'll attach the .xlsx

The program I am trying to implement is taken from Bob Wilkins book "Bioenergetics and Racehorse Ratings". As part of the final stages there is a convergence performed on all races for all horses currently running. The average racing life of racehorses is 3 - 5 years so that is what I am working...

Thanks for that. I am currently working my way through the code to make sure I understand how it works. Will get back to you..

Perfect!! Thanks for that. It does exactly what I wanted. Now my next problem is dealing with the Access limitation of 255 columns but that can wait for now.

Wow. Thanks for the response. I thought this may need some more information to aid you good folk so, I have created a sample DBase with tables and queries and also include an excel pivot table. As previously stated I am trying to establish form-lines between horses for each race. I have...

I have slowly built my horse racing database for many years and am now at the stage where I need help with some queries. Given a race with say 10 horses I want to find all races prior to the current race where at least 2 horses from current race have competed against one another. I want to look...

I have been reading this web site for several years and found it very informative. This is the first forum I have joined so will be feeling my way for a while. I'm in my 70's now and have been slowly developing my horse racing database program since last century. I purchased a copy of MS-Office...