summing a field for multiple years from a range of dates
Employee table - Stores employee data
Attendance table - A portal in the employee layout
Review table - Stores employee yearly reviews
All related by Employee_Id
I need to summarize the Tardy_Count field in the Attendance table, over a date range to show on the yearly employee review. The date range is a sliding window of time, so that there are different yearly amounts for each employee.
Examples: Date_Review is an entered date (4/11/2011) on the employees review report, Date_Start = Date_Review - 365 (4/11/2010). These dates will establish perimeters for the summary.
I've got the summary working for the first year of the reviews but it doesn't work for any years after.