I have an idea that I am not sure how to begin developing. I have a spreadsheet that has the pay period ending date, Sick and Vacation column headers. at the end of each pay period ending date the accruals of a certain amount is calculated for each employee. for example at the end of each pay period each employee accrues 4.0 hrs for vacation and 3.5 hrs for sick. I thought of putting the pay period dates in a table and calculating the accruals on the report, but how would I get the report to only see the current pay period? I really do not want to see the future pay periods because employees will be taking vacations or sick time and will not be able to calculate a current accrual status. my objective is to report the current accrual hours as of the Date()
Jim Wagner
