CROSSTAB QUERY: Combining text across columns

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

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

--
Duane Hookom
MS Access MVP


"CT" wrote in message
...
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

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

--
Duane Hookom
MS Access MVP


"CT" wrote in message
...
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

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
......

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

--
Duane Hookom
MS Access MVP


"CT" wrote in
message
...
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


.

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

--
Duane Hookom
MS Access MVP


"CT" wrote in message
...

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
.....

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

--
Duane Hookom
MS Access MVP


"CT" wrote in
message
...
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


.