Jim Assuming it's an access table i suggest you include a date field which should be populated with the current date when importing the data from the spreadsheet. Then you can set date range as criteria when producing the report you require.
HTH Liveson ----- Original Message ----- From: luvmymelody To: [email protected] Sent: Wednesday, 04 March, 2009 17:13 PM Subject: [ms_access] Help with developing an idea 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 [Non-text portions of this message have been removed]
