Hi Everyone,
I am currently dealing with a table in Microsoft Access 2003 . This is for a data conversion where my current database has a repeating Style for every barcode associated with it. The new system's table structure wants one row for each Style and the barcodes filter through multiple columns in the same row. Any help would be greatly appreciated!!
Below is a very simple example:
I have a table that looks like this:
Style Barcode
Shoe 100
Shoe 200
Shirt 300
Pant 400
Pant 500
Pant 600
Sweater 700
I need it to look like this:
Style Barcode1 Barcode2 Barcode3
Shoe 100 200
Shirt 300
Pant 400 500 600
Sweater 700
I know that as soon as someone answers this it will all click, and come back to me. In the meanwhile I seem to be stuck and very frustrated. I greatly appreciate any input whether it's through code in a module or a sql query.
Thank you!
Josh
I am currently dealing with a table in Microsoft Access 2003 . This is for a data conversion where my current database has a repeating Style for every barcode associated with it. The new system's table structure wants one row for each Style and the barcodes filter through multiple columns in the same row. Any help would be greatly appreciated!!
Below is a very simple example:
I have a table that looks like this:
Style Barcode
Shoe 100
Shoe 200
Shirt 300
Pant 400
Pant 500
Pant 600
Sweater 700
I need it to look like this:
Style Barcode1 Barcode2 Barcode3
Shoe 100 200
Shirt 300
Pant 400 500 600
Sweater 700
I know that as soon as someone answers this it will all click, and come back to me. In the meanwhile I seem to be stuck and very frustrated. I greatly appreciate any input whether it's through code in a module or a sql query.
Thank you!
Josh