Concatenating (?) words from an MSAccess crosstab query

[roxdrob01]

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

[Greg M]

Hi there,

Take a look at the attached version of your workbook, click on the "Show Available Colours" button in Cell AB1, and see if it does what you need.

It uses the following code:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your own requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

[roxdrob01]

Greg M,

This is perfect! Thank you so very much! Exactly what I need!

[Greg M]

Hi again,

Many thanks for your feedback.

You're welcome - glad I was able to help.

Regards,

Greg M