CROSSTAB QUERY: Combining text across columns

[CT]

Subject: CROSSTAB QUERY: Combining text across resulting
columns into one text string.

Any suggestions for method to combine text across columns
in crosstab query into one text string - when number of
columns and column names will vary each time query is run.
Total list of available column names is known but may grow
in future. Initial data table is almost 1 mil records.

CT

 

[Duane Hookom]

I'm having trouble visualizing what you are attempting to do. Could you
provide a small sample and justification?

 

[CT]

Resulting crosstab example:

PARTNUMBER P1 P2 P3 P5 P7 COLUMNS NAMES
XXXXX P1 P3 P7 VALUES
YYYYY P1 P2 P5


WANTED OUTPUT:
PARTNUMBER VALUE
XXXXX "P1 P3 P7" where P1 P3 P7 is one text string.
YYYYY "P1 P2 P5"

Original table format. Large number of records:

PARTNUMBER VALUE1 VALUE2
XXXXX P 1
YYYYY P 1
XXXXX P 3
YYYYY P 2
......

 

[Duane Hookom]

Create one of the Row Heading expressions using the generic concatenate
function found at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane.