Multiple items in the same field

[pezman38]

I am trying to enter multiple parts into the same field and using commas to separate them. Is there a way to create multiple records with the same information, but change the part numbers in them according to comma's?

Would look like this.

Primary Key Location Part number
789 bin89756 89756,87564,78965,12565,45896

I want it to do this in the end.

Primary
Key Location Part number
789 bin89756 89756
790 bin89756 87564
791 bin89756 78965
792 bin89756 12565
793 bin89756 45896

 

[The_Doc_Man]

You need to learn VBA and text parsing. No simple query will do this. Heck, even a "complex" query is going to have one helluva time trying do this function. I would immediatly pick up the VBA help files and start reading.

 

[neileg]

Your approach is wrong. What you say want in the end is what you should start with. You need a separate record for each part number and a one to many relationship between a table for bin locations and a table for part numbers. You can always add the part numbers together later, if you need to.