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


Joined
Oct 5, 2010
Messages
2
Reaction score
0
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
 
Ad

Advertisements

Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top