Query to obtain a specific record?

[Coach Ty]

Hello,
I have a question regarding designing a query to obtain a specified single record or row from a table. Is this even possible?
I understand top value and least value queries and filters. I've also done a lot of research in how to obtain a specified number of top or least value records.
I can't seem to find any information on how to obtain a specific record or row, after a ranking query is performed.
I have records for employees that are ranked in order of performance. Their information contains a field containing their performance score, which the ranking order is based on. It also contains a field that lists the ranking numbers in ascending order. The top performing employee is listed at the top of the order, with the ranking number one.
I need to place these employees in various positions according to their ranking position.
Whereas, the #1 ranked employee will be placed into position A, the #2 ranked employee will be placed into position B and so on.
So, I was wondering what would be the best way to do this?
Would it be best to run a macro (series of queries), which will fill the positions in sequence or to designate each position as (=) to their position in the ranking order?
1) If I did the macro, I would need to know how to design it to fill the positions in sequence.
2) If I were to designate each position to be filled by an employee in a corresponding ranking position, I would need to know how to write the expression that will place each employee according to their ranking position.
Can anyone help me?
Thanks!

 

[wiklendt]

Hello,
I have a question regarding designing a query to obtain a specified single record or row from a table. Is this even possible?
I understand top value and least value queries and filters. I've also done a lot of research in how to obtain a specified number of top or least value records.
I can't seem to find any information on how to obtain a specific record or row, after a ranking query is performed.
I have records for employees that are ranked in order of performance. Their information contains a field containing their performance score, which the ranking order is based on. It also contains a field that lists the ranking numbers in ascending order. The top performing employee is listed at the top of the order, with the ranking number one.
I need to place these employees in various positions according to their ranking position.
Whereas, the #1 ranked employee will be placed into position A, the #2 ranked employee will be placed into position B and so on.
So, I was wondering what would be the best way to do this?
Would it be best to run a macro (series of queries), which will fill the positions in sequence or to designate each position as (=) to their position in the ranking order?
1) If I did the macro, I would need to know how to design it to fill the positions in sequence.
2) If I were to designate each position to be filled by an employee in a corresponding ranking position, I would need to know how to write the expression that will place each employee according to their ranking position.
Can anyone help me?
Thanks!

can you elaborate what you mean by "will be placed into position A"... by definition, if you have an employee ranked at #1, then that IS "A", isn't it? you're just using a different ordering style (1,2,3... as opposed to A,B,C...)?

 

[Coach Ty]

These would be the positions to fill, the could easily have name such as supervisor, lead sales, inventory and so on:

Position A Position B Position C Position D
_(Jones)_ _(Barnes)_ _(B Smith) _(M Gale)_

These positions will be filled with employees accordancing to their ranking in overall performance. This field will be calculated using various expressions through queries.

Overall Performance
Name Performance Score Ranking
J Jones 200 1
A Barnes 175 2
B Smith 100 3
M Gale 90 4

I need the employees to be be placed into the corresponding positions according to their ranking. Whereas, in this scenario, J Jones is ranked #1 and should be placed into position A, A Barnes Position B, B Smith position C and M gale into position D.

I have the expressions and queries written. I have the employees name, scores and ranking numbers in order. I just need to be able to write an expression, run a query or a macro with a series of queries, to place the employees into their position according to their ranking number.