Hmm - that didn't work - it changed everything the ranking altogether and I only got ranks 1 and 2 rather than 1 through 17 that I was getting before.
Thank you though!
Tiddles
Last Activity: Mar 25 '10, 02:31 PM
Joined: Mar 11 '10
Location:
-
Dealing with Ties in a Rank Query in Access
Hi
I have a query that ranks some scores, which you kind folks helped me with. However the query isn't quite ranking tied scores as I would like. Instead of 1,2,2,4 it provides 1,3,3,4.
I have been looking at various posts and a help page at http://support.microsoft.com/kb/120608 but I can't get my syntax right to perform the query.
I am getting a little desparate as I need the db at a competition tomorrow!... -
Yay! that did it
Thank you sooooo muchLeave a comment:
-
My query ran and returned the first table in the first post until I added the following to the end of the query:
ORDER BY Res1.Class_ID, Rank;
Then it asked for the parameter value.
Before I opened this post I was trying to use the solution in the following thread, but couldn't work it out - http://bytes.com/topic/access/answer...g-subset-query.Leave a comment:
-
Umm I am not sure - I have confused myself too as I have been trying things from various threads to get this to work
Thanks you for your help!Leave a comment:
-
SELECT Results.Class_I D, Results.Dog_Han dler_ID, Handlers.Club, Results.Time, IIF([Results].[Faults]>0,[Results].[Faults],0) AS Faults, Results.Elimina ted, Results.Obstacl e, IIf([Eliminated]=Yes,100-[obstacle],[time]+[faults]) AS Score
FROM Handlers INNER JOIN (Dog_Handler INNER JOIN Results ON Dog_Handler.Dog _Handler_ID = Results.Dog_Han dler_ID) ON Handlers.Handle r_ID = Dog_Handler.Han dler_ID
GROUP BY Results.Class_I D, Results.Dog_Han dler_ID,...Leave a comment:
-
no - when I use that query and run it I get a dialogue box asking to Enter Parameter Value RankLeave a comment:
-
Ranking by Subquery in Access
Hi
I have written a query in access to rank my scores, but I would like to rank these scores within a subset of all the scores. Here is my example
Class_ID Dog_Handler_ID Club Score Rank
1 12 Wallingford 32 4
1 13 Andover 95 8
1 14 Wallingford 40 5
2 12 Wallingford 93 7
2 14 Wallingford 21 3
3 ...
No activity results to display
Leave a comment: