Hello all,
I'm currently producing a database to store details about candidates going through a selection process. Once all of the data has been entered into the db, I would like to run a query that shows a rank for each candidate based on their overall score in both their syndicate and the overall process. I have used the following DCount to work out their overall position which works perfectly:
However, I also want to display a candidate's position within their syndicate so have tried many variations of the following which all return #error when the query is run:
I've seen various posts with similar questions but my implementation of the various solutions don't seem to work. Can anyone see my (probably obvious) mistake and provide any advice/assistance?
Any comments greatly appreciated and please let me know if you need more information.
Many thanks in advance,
James
I'm currently producing a database to store details about candidates going through a selection process. Once all of the data has been entered into the db, I would like to run a query that shows a rank for each candidate based on their overall score in both their syndicate and the overall process. I have used the following DCount to work out their overall position which works perfectly:
Overall Position: DCount("*","[Data Table]","[Tasks - Weighted Score] >" & [Tasks - Weighted Score])+1
However, I also want to display a candidate's position within their syndicate so have tried many variations of the following which all return #error when the query is run:
Syndicate Pos: DCount("*","[Data Table]","[Tasks - Weighted Score] >" & [Tasks - Weighted Score] & " AND [Syndicate Number]=" & [Syndicate Number])+1
I've seen various posts with similar questions but my implementation of the various solutions don't seem to work. Can anyone see my (probably obvious) mistake and provide any advice/assistance?
Any comments greatly appreciated and please let me know if you need more information.
Many thanks in advance,
James