Hi, I have data from a MS Access crosstab query that I need to concatenate into a meaningful group of words. This table shows inventory numbers and the colors that are associated to those inventory numbers. What I need to do is somehow concatenate the words into a meaningful phrase. i.e., colors: red blue white needs to read: red, blue & white. Some will have only one color and some will have more, so I calculated the count of the colors and can assign them a specific syntax. What I am having problems with is getting the color names together easily so that I can arrange them in a meaningful way. Any help would be appreciated. Please see attached workbook for reference. TIA
Bookmarks