Okay, Here is a sample of my data.

EMPLOYEE EFFECT-DATE END-DATE Job-Bonus Code
75013 6/27/2005 6/30/2005 BY-MIY-15
75013 7/1/2005 12/31/2005 BY-MIY-15
75013 1/1/2006 6/30/2006 BY-MIY-15
75013 7/1/2006 12/31/2006 BY-MIY-15
75013 1/1/2007 6/30/2007 BY-MIY-15
75013 7/1/2007 12/31/2007 BY-MIY-15
75013 1/1/2008 3/31/2008 BY-MIY-15
75013 4/1/2008 6/30/2008 BY-MIY-15
75013 7/1/2008 BY-MIY-15
750753 5/1/2004 5/15/2004 BY-L0A
750753 5/16/2004 6/30/2004 BY-L0A
750753 7/1/2004 12/31/2004 BY-L0A
750753 1/1/2005 6/30/2005 BY-L0A
750753 7/1/2005 6/30/2006 BY-L0A
750753 7/1/2006 12/31/2006 BY-L0A
750753 1/1/2007 1/7/2007 BY-L0A
750753 1/8/2007 6/30/2007 BY-L0A
750753 7/1/2007 12/31/2007 BY-L0A
750753 1/1/2008 6/30/2008 BY-L0A
750753 7/1/2008 BY-L0A


The desired result is
EMPLOYEE EFFECT-DATE END-DATE Job-Bonus Code
75013 6/27/2005 BY-MIY-15
750753 5/1/2004 BY-L0A



--
JRussell


"Alojz" wrote:

Hi, would be helpful providing us with the structure of ur data, otherwise we
might just guess. So, place here sample of source data and desired result. I
go sleep now but somebody else will help you soon or later.

"JRussell" wrote:

How do I create a summarize report of data that is date driven? For example,
I have a table of employee job history in which employees held the same job
for several years. I want to create a summarized report that will simply
give me the start date and end date for the employee at each change in job.
How do I do that?
--
JRussell