Hello everyone,
I have a database that is tracking attendance for several 100 employees. The Db is mainly used to log any policy occurrences (no call, no show). If an associate doesn't have any occurrences for a month, then they get a point credit. Right now, I set it up so the credit can be manually added. the problem is a supervisor (the user) may not know if their associate should receive this credit unless they review their attendance report. Opening the form to add a policy occurrence, then running a report to only re-open the same attendance form is inefficient. What I’d like to have is a way to have a credit automatically added if they did not receive any points for a particular month.
I’ve never done anything like this so I’m not sure if this is possible, where to start or what the best route is.
Thank you, all for your help!
ps. My office does not allow uploading any data/files so I am not able to upload a copy/sample. I'll try to do my best to describe the setup as much as you need.