CROSSTAB QUERY: Combining text across columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

CT - 08 Oct 2004 00:41 GMT

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

Reply to this Message

Duane Hookom - 08 Oct 2004 02:46 GMT

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

Signature

Duane Hookom
MS Access MVP

> Subject: CROSSTAB QUERY: Combining text across resulting
> columns into one text string.
[quoted text clipped - 6 lines]
>
> CT

Reply to this Message

CT - 08 Oct 2004 17:55 GMT

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
[quoted text clipped - 12 lines]
>
>.

Reply to this Message

Duane Hookom - 08 Oct 2004 19:30 GMT

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

Signature

Duane Hookom
MS Access MVP

> Resulting crosstab example:
>
[quoted text clipped - 39 lines]
> >
> >.

Reply to this Message