Best way to transform a table

[siema24]

Hello,
I'm wondering what's the best way to transform tabA into multi-valued field table tlbB. Please check images I'm including below. Thank you so much in advance!

[ranman256]

You wouldn't want to.
tblB is not normalized.
but, youd need vb code to scan the recSet and concat the recs, then run append qry.

[Homegrownandy]

Maybe you should write what you are trying to achieve and provide some sample data. Im assuming you will need a junction table here instead.

[siema24]

ranman256 - actually I want to! : ) I know that multi-value field tables are evil but all I want to do with is is just print it. It won't be a part of a any additional relation that could causes problems.
Is there any way in access to pertofm this kind of a transformation?

[orange]

see this Allen Browne article

remember data storage structure is not the same as data presentation.

[siema24]

orange - you are right. In fact I don't need to transform tblA. All I need to do is to create a report / query to inform user that "1 is assigned to elements a,b,c, 2 is assigned with elements d,e" etc. What approach what do you think will be the best? Thanks!