Tracking Time Off
I set up a Time Off Tracking system in an HR database. This system tracks time off accruals and remaining balance (based on how many hours an emplyee used). everything is working fine, but I am stuck on one area. I want the system to total the amount of unsed days at the end of each year and record the number in each record. I then want the system to reset accruals to zero for January 1st of every year and start accruing all over again.