You have chosen to sponsor your bid up to a maximum amount of .
I decided to repost this project with more detail. I have various information relating to horse racing. This includes 17 individual ratings which can be supplied in csv format.
The database requires a separate front and back end.
There must be the ability to import data to produce the day`s racing cards.
There must be the ability to import the days results to update the database.
There needs to be a front end query with multiple options similar to the one found here : http://adrianmassey.no-ip.org/web1/db3/thaccess.php?flat=-1&p1=ejlub2JvZHl1dQ==&p2=NWw5Wm5vcGFzc3dvcmRd&p3=MTM1OTM2ODQ3MQ==
There are 17 individual ratings for each horse – These need to be ranked for each race ie. The highest number in each race for each rating is ranked 1 and so on. The ranking needs to be done automatically as the data is imported.
Following on from this there needs to be the ability to see how the top rated performed at each course and type of race eg Top rated (ranked 1) in Master rating in 2 mile handicap races at Ascot and so on. This needs to show how many selections, how many winners and profit/loss.
Clicking on a horse, trainer or jockey, sire or dam should bring up all the information stored in the database for that query.
I will supply all the past data for the last year but will need the ability to import previous years data into the database.
This will be an ongoing project with regular future queries etc to write.
I have attached a sheet of yesterday`s racecards which need to be exported from the database when complete.
I need to be able to import the next days racing details directly into the database and produce race cards for the days racing.
I also need to be able to import the previous days results into the database in a simple format as the ratings for each horse will already be there.
This needs to be able to work as a stand alone program.
I am not concerned with the format this can be access,oracle,mysql or filemaker or any other suitable format.