MS Access and rotate data
Posted on 2016-11-02
Is there a way to rotate data in SQL or other mechanism in MS Access? For example, say I have 3 records of data, say text string of colors - "blue", "red", "green". Is there a way to return a concatenation of all three colors in one string in one record?