Search results

Again, apologies for the confusion. The problem for the original data set is solved. I now need a number of variations on this query, where a subset of the results is required for a number of different championships, each indicated by a flag (local trophy, tourist trophy, hill climb trophy...

Jdraw, thanks to your help I have got the query working. I added an ORDER BY argument - Dupe.Points DESC this seemed to fix it - I would have expected it to affect the order of the output records, not the number - mmmm. The code is below. SELECT qLeague.Member, qLeague.Points FROM...

Thank you for your continued help, however, the TOP 10 function does not seem to filter out any records (i.e. 15 are displayed for the first member). The code used is: SELECT qLeague.Member, qLeague.Points FROM qLeague WHERE qLeague.ResultsID In (SELECT TOP 10 ResultsID FROM...

Apologies for the confusion, to clarify the following are the expected results for member "Alex Peters" - ten values including the highest point duplicates Alex Peters 15 Alex Peters 13 Alex Peters 11 Alex Peters 9 Alex Peters 9 Alex Peters 8 Alex Peters 7 Alex Peters 7 Alex...

Thank you very much for your kind help. I apologise that I hadn't explained the problem sufficiently clearly to do with duplicate scores - the desired result is to select the top 10 highest scores (even if they are the same value). My problem with access is that it counts all scores with...

I have seen many other posts on this forum relating to TOP n Subqueries, but unfortunately none have helped to solve my issue. I have a race league, I want to select the top 10 point scores for each member. I have read the Allen Browne article (and many others) and tried many variations on...