columnar output by group variable values

[Peter]

MS Access allows printing record details by a group value. It begins a new
horizontal section on each value in the grouped variable. Is there a way of
doing the same thing to produce vertical (columnar) output? That is, on each
new value in the group variable it prints a new column of records data.

 

[Marshall Barton]

MS Access allows printing record details by a group value. It begins a new
horizontal section on each value in the grouped variable. Is there a way of
doing the same thing to produce vertical (columnar) output? That is, on each
new value in the group variable it prints a new column of records data.

Not really, but you can use a multi-column report and set
the group header section NewRorOrCol property.

 

[Peter]

Thankyou very much for the advice, Marshall. It looks promising. Could you
pls tell me how I go about "using a column report"? What do i activate apart
from the property setting as you suggest - or is that all?
Thank again.

 

[Marshall Barton]

Thankyou very much for the advice, Marshall. It looks promising. Could you
pls tell me how I go about "using a column report"? What do i activate apart
from the property setting as you suggest - or is that all?

The number of columns in a report is specified using the
File - Page Setup - Columns menu item. Also check the Down
then Across column snaking option. If you want your
page/report header/footer sections to span across the entire
page, then uncheck the Same as Detail option and set the
column width manually.

 

[Peter]

Beaudy mate! I will give it a go.

Merry Christmas and thanks again Marshall.

-- Peter