General Betting
There is currently 1 person viewing this thread.
These 50 comments are related to the topic:
Access Query help required
Access Query help required
sort by:
Show
per page
Replies: 50
|
By:
Grey Shot,
I am going to try this reply using the forum Beta version to see if I can get round the truncating of the replies. The code is: SELECT racesAlias.Track, racesAlias.Horse, racesAlias.[Race date], racesAlias.Rating, CStr((Select Count(*) from races Where [Horse] = [racesAlias].[Horse] And [Race date] > [racesAlias].[Race Date])+1) AS Ranking FROM races AS racesAlias WHERE (((CStr((Select Count(*) from races Where [Horse] = [racesAlias].[Horse] And [Race date] > [racesAlias].[Race Date])+1)) |
|
By:
Nope, 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 "Where... line after the +1)) bit
I think the less that symbol, ie the sideways v pointing to the left is the character causing the truncating. Rgds dog |
|
By:
html entities removed ie lt gt etc
|
|
By:
All many thanks, I have not been in much over the wekend so will digest asap and give feedback
Thanks for all the replies |
|
By:
Buy 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=used Grey Shot, did you understand the method I suggested? You can do this with a series of queries (put together in a macro will reduce it to a double click, or a single click if you put a button tied to run the macro on a form. I am currently working on my own web based formbook. I have nearly finalised it. I generate a web page for each race result and one with each horses form. I have all manner of stats and hyperlinks, inlcuding hyperlinks to play all the races from the pages. The horses pages link to the results pages and vice versa. I generate my speed ratings each day and have hyperlinks to the form pages for every horse. I believe my web based form book to be better than the racing post's and ATRs! |
|
By:
^ That may be a slight exageration
 |
|
By:
 |
|
By:
Guys, with the truncating I am getting confused , I told you I was a novice. However if you want to copy it into a comms
gt09876 Yahoo I am based in the UK Thanks |
|
By:
Stowe, 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 thanks dogform for constantly trying to help. Hope to hear from you all soon Thanks again |
|
By:
Grey Shot,
Sent you SQL via email to what I interpreted as your email address from your reply. Rgds dog |
|
By:
Dogform, its official, you are a genius . Many thanks and also to all the posters who will enable me now to sleep at night
Many thanks |