Hi Paul,
I just put dummy dates in the first 9 rows and guess what, you are a genius!!

One last question before I let you escape, how do I get the English date format in the word doc. It is displayed correctly in the database but changes to the US format in Word.

7th April 2014 becomes 4/7/2014

Cheers,

Andy