Z
Zeunasc
I need help designing a database that keeps up with a point system we
have here at work. I'll tell you what I know.
First, I have a list of all the employee names for a table.
Second, for various reasons that I don't want to go in to, people can
earn points, in half point increments, toward a reward.
Now for the tricky part. The points are calculated on a 12 month
rolling sum. For every 3 months that an employee goes without getting
any points, a point is dropped from their total. Also, at the 13th
month, any points earned during the first month are dropped from their
total.
Given these rules, here is what I need out of this database. Every
day, the supervisors will need to open the database, and use a form to
pick the user's name, enter a date, points earned, and any comments.
Then, they should run one of three reports - 1) show me all of the
names and how many points they currently have, and 2) show me the
people that have gone 3 months without earning any points, and 3) show
me the people that have gone all 12 months without earning any points.
So, I know I will need a table of employee names, and a table to hold
the data that is entered by the supervisors. It's the rest of it... I
can't figure out how to get started.
Any help is appreciated. Please write if you need more information
about any part of this.
Thanks!
Tim
have here at work. I'll tell you what I know.
First, I have a list of all the employee names for a table.
Second, for various reasons that I don't want to go in to, people can
earn points, in half point increments, toward a reward.
Now for the tricky part. The points are calculated on a 12 month
rolling sum. For every 3 months that an employee goes without getting
any points, a point is dropped from their total. Also, at the 13th
month, any points earned during the first month are dropped from their
total.
Given these rules, here is what I need out of this database. Every
day, the supervisors will need to open the database, and use a form to
pick the user's name, enter a date, points earned, and any comments.
Then, they should run one of three reports - 1) show me all of the
names and how many points they currently have, and 2) show me the
people that have gone 3 months without earning any points, and 3) show
me the people that have gone all 12 months without earning any points.
So, I know I will need a table of employee names, and a table to hold
the data that is entered by the supervisors. It's the rest of it... I
can't figure out how to get started.
Any help is appreciated. Please write if you need more information
about any part of this.
Thanks!
Tim