Concatenate in a cross tab query in Access 2007

[Darius]

I have inherited an old database in Access 2007 which needs a quick fix in one query.

I have a cross tab query which is only bringing the first value of all the cross tab values. However, what I need is to concatenate all the values (designation abbreviations) into this field and not only bring the first one. Is there an easy way of doing this in the current query designer?

[ranman256]

concatenate in the query that the Crosstab uses.

[Darius]

Do you mean in "Master_List_for_cross_tab" query? How do I do that in that in the query that the Crosstab uses?

[CJ_London]

investigate using the concaterelated function here

http://allenbrowne.com/func-concat.html