Merging text data in cross-tab query

hongluen via AccessMonster.com · Mar 23, 2007

Greetings,
In a Crosstab Query, we can sum up numbers.
But, if all data is text, can we merge the text into one value in a Crosstab
Query?
Thanks.

Guest · Mar 23, 2007

You can use the generic concatenate function at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane as the
value in a crosstab.