Create MS Access FUNCTION (VBA) to calculate attendance/bonus
Budget: $30 – $250 USD
Need for someone to create a function for an MS Access database that calculates total points using a rolling calendar attendance table. You can bid, but I am aiming for $50.00 for this project.
Rules:
1. Points expire 1 year after receiving
2. After going each 90 days with no points, a 1 point credit is awarded on the 90th date. This credit will expire 1 year after the point was awarded. If it goes 180 days then you would have another 1 point credit and that would expire one year after receiving it, etc, UP TO 3
3. Can not have more than 3 bonus points active in any rolling 365 days, If you have 4, kill the OLDEST one
4. Points can never go below 0
I have attached a dummy database and started the function. It is not working and shouldn't be used. What I would recommend is to populate an array to account to each point, each POSSIBLE credit (remember you can have more than one (up to 3), so you need to add additional logic dates) sort by date, see if anything is expired and add or subtract one line at a time without going below zero and without having more than 3 bonus credits in any rolling 365.
I hope this is clear, if not please ask. I gave some hints in the function if you are on the right track.
Rules:
1. Points expire 1 year after receiving
2. After going each 90 days with no points, a 1 point credit is awarded on the 90th date. This credit will expire 1 year after the point was awarded. If it goes 180 days then you would have another 1 point credit and that would expire one year after receiving it, etc, UP TO 3
3. Can not have more than 3 bonus points active in any rolling 365 days, If you have 4, kill the OLDEST one
4. Points can never go below 0
I have attached a dummy database and started the function. It is not working and shouldn't be used. What I would recommend is to populate an array to account to each point, each POSSIBLE credit (remember you can have more than one (up to 3), so you need to add additional logic dates) sort by date, see if anything is expired and add or subtract one line at a time without going below zero and without having more than 3 bonus credits in any rolling 365.
I hope this is clear, if not please ask. I gave some hints in the function if you are on the right track.