Report w/columns

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ernst Guckel - 29 Mar 2008 02:36 GMT

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.

Reply to this Message

Duane Hookom - 29 Mar 2008 07:15 GMT

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.

Signature

Duane Hookom
Microsoft Access MVP

> Hello,
>
[quoted text clipped - 7 lines]
>
> Ernst.

Reply to this Message