Cheers Chris!

As this was access, I needed to put brackets around this so it worked, but that did the trick thanks!!!!

Code:
From (Table1 t1 Inner Join Table2 t2a On t1.[Col1] = t2a.[ID])
Inner Join Table2 t2b On t1.[Col2] = t2b.[ID]