I have a query which calculates the data from two table and then yields the number of points based on various calculations for each category.
Essentially we are trying to rank our Agents based on performance, and each category (Senority, Sales, occurances etc) has a points value. We have a final query that combines all these points values for the different categories to yeild the final total.
What I need is a query that will show the rank of the Agent based on this points value, but gives the same value if a tie is in place.
I have Agent Name as one field in the query and Total Points as the other. I would need a third field Rank, and the only thing I could find was:
- Seniority: (Select Count(*) from Employees Where [HireDate] < _
-
[Emp1].[HireDate]+1;)
Which is an example given on Microsoft help, but I played with it and still have no idea what to change to give the correct result, it gives me the Syntax error. I was hoping someone could point me in the right direction.
Thanks.
Stephanie