New Posts For Thread: MS Access Helphttps://community.betfair.com/general_betting/go/thread/view/94082/29071025/ms-access-helpHi, I am currently trying to master MS access and failing horribly. For the sake of this example I have a database containing Race ID, and which horse has won, placed and finished 3rd. I have managed to produce separate query's which count the numberStow_Judge, Yeahyeah and ror thank you so much for your replies. I am still digesting what has been said but I will get back to you guys to let you know if I have been successful with it. Thanks for taking the time to give me advice.https://community.betfair.com/general_betting/go/thread/view/94082/29071025/ms-access-help?post_id=518855771#518855771Stow_Judge, Yeahyeah and ror thank you so much for your replies. I am still digesting what has been said but I will get back to you guys to let you know if I have been successful with it. Thanks for taking the time to give me advice.Sat, 21 Apr 2012 03:25:23 -0500BTW if you're not comfortable using SQL you can still create and use subqueries through the query creator, just create the subqueries as queries then create a new query and you can query from those queries as if they were tables (just click add tablehttps://community.betfair.com/general_betting/go/thread/view/94082/29071025/ms-access-help?post_id=518845315#518845315BTW if you're not comfortable using SQL you can still create and use subqueries through the query creator, just create the subqueries as queries then create a new query and you can query from those queries as if they were tables (just click add tableFri, 20 Apr 2012 17:06:25 -0500This is how I'd design this.TABLESRACE (RaceID (auto), LocationID (int), Runners (Maybe leave this out?), RaceTime (int))RACE_RESULT (Race_ResultID, RaceID, Place (int), HorseID, Completed (bool),IsPlace (bool))HORSE (HorseID, HorseName)LOCATION (Lochttps://community.betfair.com/general_betting/go/thread/view/94082/29071025/ms-access-help?post_id=518845261#518845261This is how I'd design this.TABLESRACE (RaceID (auto), LocationID (int), Runners (Maybe leave this out?), RaceTime (int))RACE_RESULT (Race_ResultID, RaceID, Place (int), HorseID, Completed (bool),IsPlace (bool))HORSE (HorseID, HorseName)LOCATION (LocFri, 20 Apr 2012 17:04:53 -0500However you approach it, this is a big project so don't go beating yourself up if you don't make it. You sound as though you're creating your queries through the Access query grid (sometimes called QBE, short for query by example) and although thathttps://community.betfair.com/general_betting/go/thread/view/94082/29071025/ms-access-help?post_id=518843657#518843657However you approach it, this is a big project so don't go beating yourself up if you don't make it. You sound as though you're creating your queries through the Access query grid (sometimes called QBE, short for query by example) and although thatFri, 20 Apr 2012 16:10:49 -0500Download the racing sense database. (free) It has the last 10 years or so of form. (Flat & NH)It's a '97 database, but you can link the tables to another database in a later version. I don't think your idea of previous placings will get you too far.https://community.betfair.com/general_betting/go/thread/view/94082/29071025/ms-access-help?post_id=518808895#518808895Download the racing sense database. (free) It has the last 10 years or so of form. (Flat & NH)It's a '97 database, but you can link the tables to another database in a later version. I don't think your idea of previous placings will get you too far.Thu, 19 Apr 2012 17:14:59 -0500Hi, I am currently trying to master MS access and failing horribly. For the sake of this example I have a database containing Race ID, and which horse has won, placed and finished 3rd. I have managed to produce separate query's which count the numberhttps://community.betfair.com/general_betting/go/thread/view/94082/29071025/ms-access-help?post_id=518801801#518801801Hi, I am currently trying to master MS access and failing horribly. For the sake of this example I have a database containing Race ID, and which horse has won, placed and finished 3rd. I have managed to produce separate query's which count the numberThu, 19 Apr 2012 13:48:24 -0500