PLEASE HELP ME FRIENDS -- IT IS VERY URGENT.

I have to make an employee attendance sheet in which i have to display only those employees which are present for 9 or more than 9 days continuously. Also here continuous means all those days on which employee is present regardless of that day, i.e whether the day is a holiday or public holiday if employee is present and it is coming in the continuous 10 days chunk then it should be displayed. Now the problem is that i am able to get the maximum working days for each employee as well as the dates from which his/her 10 date continuously present started and the date at which it ended. Now the only problem that i am getting is that i have placed all this information in detail section, and the problem starts here that all the employee records which are coming 10 or more days appears with an unusual format e.gEmpId  EmpName                WorkingDays        DateFrom        DateTo34         Hassan Ali                    10                   8/22/2008     8/31/200835         Muhammad Khalil         10                   8/1/2008       8/10/200835         Muhammad Khalil         11                   8/1/2008       8/11/200835         Muhammad Khalil         12                   8/1/2008       8/12/200835         Muhammad Khalil         10                   8/18/2008     8/27/200835         Muhammad Khalil         11                   8/18/2008     8/28/200835         Muhammad Khalil         12                   8/18/2008     8/29/200835         Muhammad Khalil         13                   8/18/2008     8/30/200835         Muhammad Khalil         14                   8/18/2008     8/31/2008now i only want to retrieve the maximum of these working days for each employee id i.e only the following record should be displayedEmpId   EmpName             WorkingDays       DateFrom       DateTo
34         Hassan Ali                    10                   8/22/2008     8/31/200835         Muhammad Khalil         12                   8/1/2008       8/12/200835         Muhammad Khalil         14                   8/18/2008     8/31/2008Please help me as it is urgent, because it is an assignment given to me by my boss and already the task has gone into a long delay. Please help me
URGENT PLEASE HELP ME FRIENDS -- IT IS VERY URGENT AND IMPORTANT.

Edited by farrukh_123 - 16 May 2010 at 7:23pm