[sign]Amazing!!!![/sign]

rbrhodes That is absolutely brilliant. It does exactly what it says on the tin :o)

OK, so now that I can use the macro above to convert the appropriate columns into date format, and put them into UK format.....

xld, will you be able to have a look at this data now and help with the original query???

Thanks everyone, you guys rock..