I'm using Allen Browne's "ConcatRelated" function to do the following: I have a Many-To-Many relationship between the tables Products, Prod_Cat_Spec and Categories (The Prod_Cat_Spec is a junction table wich connects the other two tables with the many-side on itself and one-side on the other 2 tables).
I would like to make a new query (or table, or add to a empty table) with one product on each row but with an extra field that has concated all categories for each product so one row looks like this (the | sign represents the fields):
productID | Category1,Category2,Category3 [etc...] | productName | Weight [etc...]
lastly I'd like to separate the Categories with the "@" sign instead of the comma sign, and additionally add the text string "MyProducts/" before Each Category lke this:
productID | (e-mail address removed) [etc...] | productName | Weight [etc...]
How should the query look like?
I would like to make a new query (or table, or add to a empty table) with one product on each row but with an extra field that has concated all categories for each product so one row looks like this (the | sign represents the fields):
productID | Category1,Category2,Category3 [etc...] | productName | Weight [etc...]
lastly I'd like to separate the Categories with the "@" sign instead of the comma sign, and additionally add the text string "MyProducts/" before Each Category lke this:
productID | (e-mail address removed) [etc...] | productName | Weight [etc...]
How should the query look like?