By the way the pivot table will look like this (but formatted):

Data
EMPLOYEE Job-Bonus Eff Date End Date
75013 BY-MIY-15 6/27/2005 6/30/2008
750753 BY-L0A 5/1/2004 6/30/2008

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

Cheers,
Shane Devenshire


"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