@JLS
Thanks but I needed to be more precise over the ordering than just using date.
Genius!
Definately is giving me the right results for the #tmp sample data set. As you would expect the 'real' data is much more complicated. I will run against this later and see what the performance is like and whether any other anomolies crawl out of the dataset.
Obiron