Question How do I keep a running tally of points per person?

[michellecahal]

We have started a "points program" for our bus drivers. Each offense they incur adds points to their score. This is a yearly cycle. So, I need to keep track of the points they earn, adding them up by year.

Thanks!

 

[MarkK]

Hi there and welcome to the forum.
Are you implementing your new points program using software? And if so, what software?
I wouldn't add up the points by year. Rather, I would keep a record of each violation by date and by employee, and the number of points incurred. Then, to determine an employee's point score calculate it from your stored data as required. Also, if there is a mechanism by which points are reduced over time, enter those events as if they were a 'negative violation'. This will be a lot like a listing of a bank account, except not using dollars, and you can periodically issue 'statements' that indicate and employees current 'balance.'
Cheers,
Mark

 

[michellecahal]

So sorry! I'm using Access 2010. And your comparison to a bank account truly helps! Thanks so much!

 

[michellecahal]

I'm still having trouble with this.

In my DriverTotalPoints Query, I've TOTALED each column (achievement points and offense points). When there is a total for each column per person, the Total column works with the expression....

Total: Sum([DriverOffense]![PointsForOffense]-[DriverAchievement]![PointsGiven])

If the person has only an offense total with no achievement total, the Total field stays blank.

How do I subtract the Achievement points from the Offense points?