Hi,

You can do this with a PivotTable inwhich you put the Employee in the outer
Row field (to the left), and the Job-Bonus-Code as a Row field to the right.
Put the Start date in the Data area and change its calculation to Min, put
the End date into the Data area and change its calculation to Max. Format
both data field to date. Drag the Data button from the row area to the
Column area. Turn off Grand Totals.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"JRussell" wrote:

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