I would like to create a sorting and scoring sheme in Access across a number of fields in one table. If necessary, generating another table from the query.
Table has a number of categories for employees. Each category has a number associated with it.
I want Access to sort then score each category for each person IE:
NAME CALLS SPEED TIME
Joe 100 54 20
Mary 50 17 13
Jane 75 33 15
Would be
CALL SPEED TIME
NAME CALLS SCORE SPEED SCORE TIME SCORE TOTAL
Joe 100 3 54 1 20 1 5
Mary 50 1 17 3 13 3 7
Jane 75 2 33 2 15 2 6
Best Mary 7
Jane 6
Joe 5
Table has a number of categories for employees. Each category has a number associated with it.
I want Access to sort then score each category for each person IE:
NAME CALLS SPEED TIME
Joe 100 54 20
Mary 50 17 13
Jane 75 33 15
Would be
CALL SPEED TIME
NAME CALLS SCORE SPEED SCORE TIME SCORE TOTAL
Joe 100 3 54 1 20 1 5
Mary 50 1 17 3 13 3 7
Jane 75 2 33 2 15 2 6
Best Mary 7
Jane 6
Joe 5