Report Dilemma

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report Dilemma 1
Replacing information 1
Counting macro 2
Reports that sift records from different tables 0
Crosstab? 4
Countifs or a pivot 1
Math Functions Not Working Properly 3
SUMPRODUCT 3

Back
Top