Hi WolfgangE and Sean Lange,

Thank you for your responses.

WolfgangE, sorry should have been more clear in my requirements.

We have a system where an employee can be booked on a job for long periods, so in my crude example, John Doe is booked to HSBC for all of 2013. However, in between, employees can be on vacation too so John Doe has 2 vacations during the time he is booked on HSBC.

What we are looking to achieve is to split the job either side of vacation bookings so it all slots in as opposed to being stacked. I attach a screenshot as an example.

Sean Lange, thanks for the DDL. I should have provided that in the first place.

I look forward to your guidance and assistance.