H
Hugh
I have a query that returns a handicap score for each of the 16 players in
my league for each week of play. Based upon that handicap score I now need
to assign points to each player starting from the lowest score to the
highest, the lowest receiving 16 pts, next lowest 15 pts, etc. I also have
to keep a running total of each players points from week to week which I
thought I would store in a table with an update query.
We play an 18 week season but only 16 weeks of points are counted for any
one players total points. Any points won after the 16 week limit can no
longer be added to the total points of that player. If a player does not
show in any given week he is given a zero (0) score which does not count
toward his 16 weeks of active scoring.
I am working in Access 2000 and this is beyond my novice knowledge. The
query by which I acquire the handicap score has these fields which are
extracted from two other queries:
Players
Date
Score
Handicap
HdcpScore
Any genuine help would be greatly appreciated and serve to increase my
knowledge in this wonderful program.
Hugh
my league for each week of play. Based upon that handicap score I now need
to assign points to each player starting from the lowest score to the
highest, the lowest receiving 16 pts, next lowest 15 pts, etc. I also have
to keep a running total of each players points from week to week which I
thought I would store in a table with an update query.
We play an 18 week season but only 16 weeks of points are counted for any
one players total points. Any points won after the 16 week limit can no
longer be added to the total points of that player. If a player does not
show in any given week he is given a zero (0) score which does not count
toward his 16 weeks of active scoring.
I am working in Access 2000 and this is beyond my novice knowledge. The
query by which I acquire the handicap score has these fields which are
extracted from two other queries:
Players
Date
Score
Handicap
HdcpScore
Any genuine help would be greatly appreciated and serve to increase my
knowledge in this wonderful program.
Hugh