Help with viewing data in multiple columns in a report with constant row heading

[mulamootil]

Hi - Not sure if the subject makes any sense to my actual problem. I want to view size of three products made on 5 different production lines on different shifts side by side in a report. Right now I am getting a report (Access 07) something like this where both shift info is displayed one below the other for all 5 lines.

Shift 1
Size 1 Size 2 Size 3
Line1 -
Line2 -
and so on till Line 5

Shift 2
Size1 Size 2 Size 3
Line1
Line2
and so on till Line 5

Is there any way that I can view data for both shifts adjacent to each other.
Something like this
Shift 1 ............... ........... Shift 2
Size 1 Size 2 Size 3 .......... Size 1 Size 2 Size 3
Line1 -
Line2 -
and so on till Line 5
I sure appreciate any help/suggestion. Thanks.

Stan

[ADezii]

Try, in the Design View of the Report, to adjust the Column Settings, as in:

File ==> Page Setup ==> Columns Tab

[mulamootil]

Help with viewing data in multiple columns in a report with constant row heading

Thanks ADezii. I tried your suggestion, however I haven't had any luck yet and I am still playing with it....I am just slow Thanks again.