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