Merging 2 tables

[todavy]

I have an Access 2007 table with two fields, ProductName and ProductSort:


ProductName / ProductSort
juice / cool
juice / tropical
juice / natural
cola / cool
cola / artificial

And I want it to become like this:



ProductSum
juice, cool, tropical, natural
cola, cool, artificial
..etc

In other words, the ProductName field should be merged with the ProductSort field to a new textfield called ProductSum with ProductName and all related ProductSorts separated with commas (one uniqe product per row).

Is this possible by using a Query? If not how?

[RuralGuy]

I believe you should find this link helpful.

[todavy]

I was afraid of going into the VB code. But isn't it possible to solve this way?

From this table:

ProductName / ProductSort
juice / cool
juice / tropical
juice / natural
cola / cool
cola / artificial

To a new table:

ProductName / ProductSort1 / ProductSort2 / ProductSort3 / [etc...]
juice / cool / tropical / natural
cola / cool / artificial

And then concat the fields with a "&" sign to a new table. Or am I out in the ozon here...

[todavy]

I have "productcategories" on the "many"-side of a one-to-many relationship (actually there's a junction table between the products- and categories table that makes it possible for one product to belong to many categories and vice versa).

The trick is that, from the constallation above, make a .csv file (textfile) with this design:

category1@category@category2 [etc..], productId, price, weight [etc..]

Where the "@" (at) sign separates the productcategories and the "," (comma) sign separates the other product info.

I can't change the design of the .csv file. I'm using that to upload product to a webshop (Wosbee.com) and it has to be in that format.

[RuralGuy]

I do not know how to accomplish what you want without using code. Why are you reluctant to use code?