Link to home
Start Free TrialLog in
Avatar of Bobby Masterson
Bobby MastersonFlag for United States of America

asked on

create new record in Access table based on criteria

I have a table with two fields: sku and related_skus. related skus has numbers separated by a comma, like 1234,5678,4321

So the table looks like this:
User generated image

What I need to do is add a record for each comma delimited value in related_skus, so the finished table would look like:
User generated imageIs that possible?
Avatar of Andrew Porter
Andrew Porter
Flag of United States of America image

Avatar of Bobby Masterson

ASKER

Thanks. I exported the table as an Excel file and tried that... it did add columns for each comma delimited value, but what I need is a new record for each, not column. Like this:

 User generated image
ASKER CERTIFIED SOLUTION
Avatar of Fabrice Lambert
Fabrice Lambert
Flag of France image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thanks very much.