Access "Un"concatenate a field to create multiple records in MS Access

[nylorij]

I have a table that has a field with multiple values separated by commas. I want to parse out these values and create multiple records out of this one record:

COMPANY PRODUCT_SERVICES
ABC 125,20,94
DEF 04,88
GHI 22,96

I want to create this:

COMPANY PRODUCT_SERVICES
ABC 125
ABC 20
ABC 94
DEF 04
DEF 88
GHI 22
GHI 96

I then will be able to match these product/services codes to descriptions to create a directory based on those products and services, listing each company underneath the actual product/services description.

My knowledge of VBA is limited...

Help!


Lori

 

[nylorij]

Did I stump the band??

 

[floppybootstomp]

Did I stump the band??

Looks that way

 

[muckshifter]

welcome to PCReview

Did I stump the band??

You will get an answer over at ...

https://www.pcreview.co.uk/forums/forum-250.php

 

[rlee]

Hi,

I am wondering if there is a solution from nylorij post. I am encountering the same problem using Access 2007 at work.

Appreciated your reply. I am checking the website https://www.pcreview.co.uk/forums/microsoft-access-f250.html but not sure I will find anything.

Thanks.