Comments by JonCox (Top 1 by date)

Thank you for your answer. I have however come up with a different alternative that does not require creating temp tables, I am in the process of testing it. However if it does not work I will impliment this solution so thank you again