Hi Lowell,

That is MUCH easier than the code I came up with, thanks.

1 question: if I want to join other tables to tbCompDistances, should I do that right behind / after "from tbCompDistances" or should I do that after the 2 cross applies?

I am not familiair with Cross Apply so I have to look into that

I thought that Cross Apply was used with subqueries, and saw no use for it here (mostly due to not knowing how to use it)

Thanks

Hein