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

N

nylorij

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
 

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

Similar Threads

How to combine multiple rows of text cells into one cell 2
Access Enter multiple values for field in MS Access 2
Concatenate multiple records into one text string 2
Create a text string from multiple records in the same field. 3
Combine field values from multiple records as a list in a report? 2
Combine multiple records in one field in Access report 5
add multiple records to a single record in Access 2003 1
How to query a field for Absolute Value in Access 2007 7

Top