AnsweredAssumed Answered

summing a field for multiple years from a range of dates

Question asked by mikedorn on Dec 23, 2011
Latest reply on Jan 18, 2012 by mikedorn

Title

summing a field for multiple years from a range of dates

Post

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.

Outcomes