MS Access - looping thru a recordset to form a single record
Posted on 2014-10-01
I'm a novice MS Access user, perhaps you can help me figure this out. I have a dataset where there are multiple records for the same sku like this...
SKU ChoiceStr Option
YTHBLKLRG Youth, Black, LRG Age
YTHBLKLRG Youth, Black, LRG Color
YTHBLKLRG Youth, Black, LRG Size
... and I want to loop through and convert to a single record like this...
SKU Option1 Choice1 Option2 Choice2 Option3 Choice3
YTHBLKLRG Age Youth Color Black Size LRG
Can you please help?