Once again, thanks for your reply. The query was sent to me by another team member who was doing it this way. I personally said to group by the customer ref and insert the maximum date using the max function !

But the question remained, why did it work before and does not now, hence my post on here !

Thankyou for your answer, i will go back to my colleague and give them the explanantion as to why this is the case.

Best Regards

Lee