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


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
Avatar of Fabrice Lambert
Fabrice Lambert
Flag of France image

Link to home
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.