SELECT Table4.col1, IIf([FirstOfCol2]=[LastOfCol2],[FirstOfCol2],[FirstOfCol2] & [LastOfCol2]) AS Col2, First(Table4.col2) AS FirstOfcol2, Last(Table4.col2) AS LastOfcol2

FROM Table4

GROUP BY Table4.col1;