Attached is a report where I am trying to capture all employees active during a date range, plus those employees who had or not a medical benefit during a date range. The active employees date range is 1/1/2015 to 12/31/2015. The benefit date range is 4/1/2014 to 12/31/2015 or active date = 12/31/2049. The unfortunate part is I am trying to capture active benefits during a date range of 1/1/2015 to 12/31/2015, but the employee could have an active benefit from 4/1/2014 to 3/31/2015, and the report wants to see their start date as 1/1/2015 (Start Date 2). With a Calc,Display and Reset on the employee# grouping and a suppression on the Detail line I have captured most of what I need. But the Start Date 2 formula field I cannot seem to get it to appear on the group footer line as 1/1/2015 or the actual start date of an employee who started during the current year. I hope I have explained this clearly. Please advise.