Search results

Thank you so much lagbolt! Your answer got me going on. Your code worked fine! I am also posting the following that may be helpful to others. I also created a separate query "DistinctCount" as follow in order to handle ties in the ranking. Here is the "DistinctCount" query: SELECT DISTINCT...

Hello to everyone, I am facing a simple problem related to ranking ... I have attached the Table that i am working on. When i run the query i want a field that shows the ranking of the couple based on the score. Here is the query that i use: SELECT Ranking.coupleID, Ranking.Score, (SELECT...

Hi, my name is John and although i have some experience with access, i find difficult to construct more advance SQL queries :banghead: :)