Report Dilemma

[Darryl]

Reposting due to spurious cosmic destruction in newsreader:

I inherited a data structure that has a primary table with a one-to-many
relationship to a second table. Each entry in the primary table has 27
entries in the secondary table for each entry in the primary table -- an
identifier (C1, C2, etc), and a value (10, 20, 30, 40, and so on).

I need to convert this "vertical" configuration and make it horizontal. By
virtue of the data structure the report looks like:

Record No.1 Primary table row 1
C1 10
C2 20
C3 40

Record No.2 Primary table row 2
C1 10
C2 20
C3 40

Would like it to be:

Record C1 C2 C3
1 10 20 30
2 15 20 40

Has anyone faced this before? How did you solve it?
I tried a crosstab, but I need the individual score, not an aggregate value

Thanks,

Darryl

 

[John Spencer (MVP)]

I believe that you can use first or last or max or min in the crosstab query as
the value to show.

You only have one value for each primary row plus identifier.