Enhanced Crosstab queries
In crosstab queries besides count, sum, average etc., there is only the possibility to take either the first value or last value as VALUE. There is no support for concatenation of string values. It would be nice to have such a concatenation function or more generally a callback function where the user can decide how to transform the values.
Hi, I have only come to this forum new,
But if you contactenate the values into a string prior to reaching the crosstab query,
within a field within a previous query, or within the tables themselves,
then the First or Last Value will have your concatenated values in the table.