Report w/columns

[Ernst Guckel]

Hello,

I am trying to create a report with 7 columns. Col1 is the labels and col
2-6 are data. I have a report with two subreports sub1 is the labels and
sub2 is the data report. It doesn't seem to work well. I think I am going
about it all wrong. Can someone point me in the right direction?? One idea
is to create 7 subreports and just format them the way I want but then the
dilemma with that is in sub2 I want record 1 sub3 record 2 and so forth... A
little lost

Ernst.

 

[Duane Hookom]

You might want to look at this http://support.microsoft.com/kb/208491/en-us
"How to Show Only Labels in the First Column of a Report".

Another option might be to use a crosstab query.