Report Dilemma

  • Thread starter Thread starter Darryl
  • Start date Start date
D

Darryl

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?
 
Back
Top