New Posts For Thread: Access Query help requiredhttps://community.betfair.com/general_betting/go/thread/view/94082/26575001/access-query-help-requiredHi I have a horse racing databse with a row for each horses performance. Typically the Table looks like this Race date, Horse, Course, SP, Finishing Position, etc,etc, etc I need only the horses last 10 performances returned as I disregard any perforDogform, its official, you are a genius . Many thanks and also to all the posters who will enable me now to sleep at night Many thankshttps://community.betfair.com/general_betting/go/thread/view/94082/26575001/access-query-help-required?post_id=481126073#481126073Dogform, its official, you are a genius . Many thanks and also to all the posters who will enable me now to sleep at night Many thanksMon, 10 Jan 2011 16:53:26 -0600Grey Shot,Sent you SQL via email to what I interpreted as your email address from your reply.Rgdsdoghttps://community.betfair.com/general_betting/go/thread/view/94082/26575001/access-query-help-required?post_id=481124413#481124413Grey Shot,Sent you SQL via email to what I interpreted as your email address from your reply.RgdsdogMon, 10 Jan 2011 16:37:26 -0600Stowe, very interesting I am trying do do something similar but this problem keeps rearing its head with past number of performances. Once I over come this problem I then need to run my ratings historically to find the effectiveness of them Also thanhttps://community.betfair.com/general_betting/go/thread/view/94082/26575001/access-query-help-required?post_id=481122133#481122133Stowe, very interesting I am trying do do something similar but this problem keeps rearing its head with past number of performances. Once I over come this problem I then need to run my ratings historically to find the effectiveness of them Also thanMon, 10 Jan 2011 16:18:30 -0600Guys, with the truncating I am getting confused , I told you I was a novice. However if you want to copy it into a comms gt09876YahooI am based in the UK Thankshttps://community.betfair.com/general_betting/go/thread/view/94082/26575001/access-query-help-required?post_id=481121649#481121649Guys, with the truncating I am getting confused , I told you I was a novice. However if you want to copy it into a comms gt09876YahooI am based in the UK ThanksMon, 10 Jan 2011 16:14:17 -0600https://community.betfair.com/general_betting/go/thread/view/94082/26575001/access-query-help-required?post_id=481072961#481072961Mon, 10 Jan 2011 08:23:38 -0600^ That may be a slight exagerationhttps://community.betfair.com/general_betting/go/thread/view/94082/26575001/access-query-help-required?post_id=481063801#481063801^ That may be a slight exagerationMon, 10 Jan 2011 06:27:21 -0600Buy a copy of this book, it is very good. I'm finding it tough going, but the book is very well written.http://www.amazon.co.uk/gp/offer-listing/0782123244/ref=sr_1_1_olp?ie=UTF8&s=books&qid=1294655086&sr=8-1&condition=usedGrey Shot, did you understahttps://community.betfair.com/general_betting/go/thread/view/94082/26575001/access-query-help-required?post_id=481058325#481058325Buy a copy of this book, it is very good. I'm finding it tough going, but the book is very well written.http://www.amazon.co.uk/gp/offer-listing/0782123244/ref=sr_1_1_olp?ie=UTF8&s=books&qid=1294655086&sr=8-1&condition=usedGrey Shot, did you understaMon, 10 Jan 2011 04:32:17 -0600All many thanks, I have not been in much over the wekend so will digest asap and give feedbackThanks for all the replieshttps://community.betfair.com/general_betting/go/thread/view/94082/26575001/access-query-help-required?post_id=480942973#480942973All many thanks, I have not been in much over the wekend so will digest asap and give feedbackThanks for all the repliesSun, 09 Jan 2011 02:15:46 -0600html entities removed ie lt gt etchttps://community.betfair.com/general_betting/go/thread/view/94082/26575001/access-query-help-required?post_id=480882145#480882145html entities removed ie lt gt etcSat, 08 Jan 2011 13:02:40 -0600Nope, still truncated it. You should be able to reconstitute it all by adding the extra line that begins with "ORDER....below the "Where.... line and then adding the less than symbol ie a v pointing to the left followed by 11)) at the end of the "Whehttps://community.betfair.com/general_betting/go/thread/view/94082/26575001/access-query-help-required?post_id=480881077#480881077Nope, still truncated it. You should be able to reconstitute it all by adding the extra line that begins with "ORDER....below the "Where.... line and then adding the less than symbol ie a v pointing to the left followed by 11)) at the end of the "WheSat, 08 Jan 2011 12:54:13 -0600