Thank you but I'm only looking for TableA's top 5 results, and out of those five, the first cell from TableB where A's ID matches B's DIR value. This looks...

I did. However the string above is pretty intensive for someone not used to Join commands.

Thank you for this code, it works!

One issue though, yes... for more than one entry in Gallery I'm seeing duplicate recordsets. I don't know where to insert the outer apply though.

Oh my god.

Awesome! It worked right out of the box. Thank you so much. 🙂