I had thought of that initially but as 7 columns, I wanted to see if there was an easier solution. Thanks for your answer.

Thank you Florent.Works perfectly. Appreciate your help and patience.Cheers,Neil

Thank you Florent.Works perfectly. Appreciate your help and patience.Cheers,Neil

Hi Florent,I sent the details in a PM.Thanks,Neil

Hi Florent,I sent the details in a PM.Thanks,Neil

Thanks, I am now getting a different error:17/10/2016 14:17:31    504734_3_1_G W3 JOIN wkf369504734_3_1 W2 ON (W2.iRowId = W3.iRowId) WHERE (((T1.tsLog > Coalesce(W2.tsBroadLogRcp3Event , W2.tsBroadLogRcp2Event , W2.tsBroadLogRcp1Event)) AND (T1.iUrlId <> 1)) AND (W2.iRowId = W.iRowId)) AND ((T1.iTr...

Thanks, I am now getting a different error:17/10/2016 14:17:31    504734_3_1_G W3 JOIN wkf369504734_3_1 W2 ON (W2.iRowId = W3.iRowId) WHERE (((T1.tsLog > Coalesce(W2.tsBroadLogRcp3Event , W2.tsBroadLogRcp2Event , W2.tsBroadLogRcp1Event)) AND (T1.iUrlId <> 1)) AND (W2.iRowId = W.iRowId)) AND ((T1.iTr...

Hi Florent,This is great. I am encountering an error along the way though and its probably something straight forward I am not doing. I cannot see a field for @eventDate in the broadlogRcp1 etc...Thanks,Neil

Hi Florent,This is great. I am encountering an error along the way though and its probably something straight forward I am not doing. I cannot see a field for @eventDate in the broadlogRcp1 etc...Thanks,Neil

Thank you Florent. Appreciate the help.