Assigning point values

[Bill]

I have a database ASJ that contains scores by individual within age groups.
I rank the scores by individual from low to high for each agegroup. I need
to update the ASJ database for each individual with a point value based on
their score. If the score is the same for individuals in an agegroup each
receives the same number of points. I need the points to be generated by
access. 10 for 1st, 9 for 2nd, 8 for 3rd, etc. or 10 for 1st and 10 for all
ties with 1st etc.

How can I achieve that using Access 2007?

Thank you for your help.

 

[Jeff Boyce]

Bill

I may not be fully understanding your situation, but on the surface, it
looks like the "points" you want to assign can be easily calculated as "11
minus the [rank]"

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Bill]

Jeff, thanks for your reply. Let me explain a little further. I calculate
the difference in what a players score is versus what he should have scored.
Example: 68 versus 72 the result is 4. I do that for each golfer. Then
based on their + or - outcome, I have to assign a point value to them.
Example: 1st gets 10 points, 2nd gets 9 points. I cannot use the calculated
difference because it could be -4 for the winner and using 11 minus the
difference/rank would yield -15. Does this help any?
--
Thank you for your help.

Bill

I may not be fully understanding your situation, but on the surface, it
looks like the "points" you want to assign can be easily calculated as "11
minus the [rank]"

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a database ASJ that contains scores by individual within age groups.
I rank the scores by individual from low to high for each agegroup. I
need
to update the ASJ database for each individual with a point value based on
their score. If the score is the same for individuals in an agegroup each
receives the same number of points. I need the points to be generated by
access. 10 for 1st, 9 for 2nd, 8 for 3rd, etc. or 10 for 1st and 10 for
all
ties with 1st etc.

How can I achieve that using Access 2007?

Thank you for your help.

 

[Jeff Boyce]

I guess I'm still undercaffeinated this morning.

I thought that YOU were assigning 1st, 2nd, 3rd ... (i.e., 1, 2, 3, ...),
and THEN wanted to provide "points", where 1st (i.e., 1) received 10 points,
and 2nd (i.e., 2) received 9 points, etc. I believe subtracting the rank
from 11 does that.

What about my description above is inaccurate?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff, thanks for your reply. Let me explain a little further. I
calculate
the difference in what a players score is versus what he should have
scored.
Example: 68 versus 72 the result is 4. I do that for each golfer. Then
based on their + or - outcome, I have to assign a point value to them.
Example: 1st gets 10 points, 2nd gets 9 points. I cannot use the
calculated
difference because it could be -4 for the winner and using 11 minus the
difference/rank would yield -15. Does this help any?
--
Thank you for your help.

Bill

I may not be fully understanding your situation, but on the surface, it
looks like the "points" you want to assign can be easily calculated as
"11
minus the [rank]"

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a database ASJ that contains scores by individual within age
groups.
I rank the scores by individual from low to high for each agegroup. I
need
to update the ASJ database for each individual with a point value based
on
their score. If the score is the same for individuals in an agegroup
each
receives the same number of points. I need the points to be generated
by
access. 10 for 1st, 9 for 2nd, 8 for 3rd, etc. or 10 for 1st and 10
for
all
ties with 1st etc.

How can I achieve that using Access 2007?

Thank you for your help.

 

[Bill]

Sorry, Jeff. I confused you with my example. I am NOT assigning 1st, 2nd,
3rd, etc. The ranking is a number that is derived from calculation. Based
on that I need to award points similar to the below example.

Calculated Need to automate
asssiging
Should shoot Shoots Rank Points
72 68 -4 10
74 70 -4 10
75 72 -3 9

72 70 -2 8
72 72 0 7
70 71 1 6

etc.

In the example above if I can figure out how to translate the -4's into 1st
place, and the -3 into 2nd place, etc., the subtracting from 11 would work
great.

I hope this clarifies what I can't figure out how to automatically do a
little better.
--
Thank you for your help.

I guess I'm still undercaffeinated this morning.

I thought that YOU were assigning 1st, 2nd, 3rd ... (i.e., 1, 2, 3, ...),
and THEN wanted to provide "points", where 1st (i.e., 1) received 10 points,
and 2nd (i.e., 2) received 9 points, etc. I believe subtracting the rank
from 11 does that.

What about my description above is inaccurate?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff, thanks for your reply. Let me explain a little further. I
calculate
the difference in what a players score is versus what he should have
scored.
Example: 68 versus 72 the result is 4. I do that for each golfer. Then
based on their + or - outcome, I have to assign a point value to them.
Example: 1st gets 10 points, 2nd gets 9 points. I cannot use the
calculated
difference because it could be -4 for the winner and using 11 minus the
difference/rank would yield -15. Does this help any?
--
Thank you for your help.

Bill

I may not be fully understanding your situation, but on the surface, it
looks like the "points" you want to assign can be easily calculated as
"11
minus the [rank]"

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a database ASJ that contains scores by individual within age
groups.
I rank the scores by individual from low to high for each agegroup. I
need
to update the ASJ database for each individual with a point value based
on
their score. If the score is the same for individuals in an agegroup
each
receives the same number of points. I need the points to be generated
by
access. 10 for 1st, 9 for 2nd, 8 for 3rd, etc. or 10 for 1st and 10
for
all
ties with 1st etc.

How can I achieve that using Access 2007?

Thank you for your help.

 

[Jeff Boyce]

Bill

I don't recall how or where just now (I haven't done it, but I've seen it),
but you should be able to find several examples of using a query to derive a
"rank" calculation on a sorted recordset. Try searching on-line for MS
Access and rank order and query.

Good luck!

Regards

Jeff Boyce
Microsoft Office/Access MVP

Sorry, Jeff. I confused you with my example. I am NOT assigning 1st,
2nd,
3rd, etc. The ranking is a number that is derived from calculation.
Based
on that I need to award points similar to the below example.

Calculated Need to
automate
asssiging
Should shoot Shoots Rank Points
72 68 -4 10
74 70 -4 10
75 72 -3 9

72 70 -2 8
72 72 0 7
70 71 1 6

etc.

In the example above if I can figure out how to translate the -4's into
1st
place, and the -3 into 2nd place, etc., the subtracting from 11 would work
great.

I hope this clarifies what I can't figure out how to automatically do a
little better.
--
Thank you for your help.

I guess I'm still undercaffeinated this morning.

I thought that YOU were assigning 1st, 2nd, 3rd ... (i.e., 1, 2, 3, ...),
and THEN wanted to provide "points", where 1st (i.e., 1) received 10
points,
and 2nd (i.e., 2) received 9 points, etc. I believe subtracting the rank
from 11 does that.

What about my description above is inaccurate?

Regards

Jeff Boyce
Microsoft Office/Access MVP

Jeff, thanks for your reply. Let me explain a little further. I
calculate
the difference in what a players score is versus what he should have
scored.
Example: 68 versus 72 the result is 4. I do that for each golfer.
Then
based on their + or - outcome, I have to assign a point value to them.
Example: 1st gets 10 points, 2nd gets 9 points. I cannot use the
calculated
difference because it could be -4 for the winner and using 11 minus the
difference/rank would yield -15. Does this help any?
--
Thank you for your help.


:

Bill

I may not be fully understanding your situation, but on the surface,
it
looks like the "points" you want to assign can be easily calculated as
"11
minus the [rank]"

Regards

Jeff Boyce
Microsoft Office/Access MVP

I have a database ASJ that contains scores by individual within age
groups.
I rank the scores by individual from low to high for each agegroup.
I
need
to update the ASJ database for each individual with a point value
based
on
their score. If the score is the same for individuals in an
agegroup
each
receives the same number of points. I need the points to be
generated
by
access. 10 for 1st, 9 for 2nd, 8 for 3rd, etc. or 10 for 1st and 10
for
all
ties with 1st etc.

How can I achieve that using Access 2007?

Thank you for your help.