Thank you Peter, again you have been very helpful, now I have to work out what you have done. I added the # becuase I was lazy (and the original excel sheet was from the US) so I have changed that.
When I re create your query I take it I change the t1 and table1 to the correct table names? Also, what is td?
As for if its learning or real work, its a bit of both really.
I would also like to thank him for helping me with CF and SQL Queries.
From me he will receive 7 lashes with a wet noodle.