K
KentuckyDiane
Please Help
I am trying to develop a database for work to track attendance.
There is a trick
Step one - A person gets a point on a certain date [Ex:1/1/04]
Step two - If the person does not get any points in the next 31 days [2/1/04] they receive a reward of -1, continuing on every 31 one days after that receiving a -1 for every 31 days they do not get an occurance.
Step three - When they do get an occurance, the new point value is added to what was remining but step two starts all over again with the new date.
Occurance example .5 point for tardies and 1 point for absent The maximum points a person can get is 12 before being fired.
I am not very good at VB - I am sure there is some huge formula that would make this work.
I am pulling my hair out
I am trying to develop a database for work to track attendance.
There is a trick
Step one - A person gets a point on a certain date [Ex:1/1/04]
Step two - If the person does not get any points in the next 31 days [2/1/04] they receive a reward of -1, continuing on every 31 one days after that receiving a -1 for every 31 days they do not get an occurance.
Step three - When they do get an occurance, the new point value is added to what was remining but step two starts all over again with the new date.
Occurance example .5 point for tardies and 1 point for absent The maximum points a person can get is 12 before being fired.
I am not very good at VB - I am sure there is some huge formula that would make this work.
I am pulling my hair out