Mate that's exactly what I needed! I had to adjust slightly but in essence I just created a union between the different results. I was worried it would run really...

Mate that's exactly what I needed! I had to adjust slightly but in essence I just created a union between the different results. I was worried it would run really...

I gave up on the first query - was 30 mins and counting! Massively appreciate your time Chris.

Ive tried another way albeit a copout from the IF EXISTS method -...

Thanks for that - it pulls out what I need but the query time is 8mins (and counting!) I know its difficult to say as you cannot see the structure...