If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Report Dilemma
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 |
#2
|
|||
|
|||
Report Dilemma
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. Darryl wrote: 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 |
Thread Tools | |
Display Modes | |
|
|