Columns and Grouping

[jdb]

I have a table of alumni from a high school.

I designed a report that lists the alumni by year, 3 columns per page.

I cannt figure out how to make it so each year prints on its own page(s).
I've played with the grouping, group header, group footer, etc but just
cannt get it right.

Any suggestions?

Thanks

 

[Larry Linson]

I have a table of alumni from a high school.

I designed a report that lists the alumni by year, 3 columns per page.

I cannt figure out how to make it so each year prints on its own page(s).
I've played with the grouping, group header, group footer, etc but just
cannt get it right.

Check the Force New Page property of the Group Header -- that is likely the
answer... ir you Group on year and specify new page Before, that ought to
work.

Larry Linson
Microsoft Access MVP

 

[jdb]

Thanks, but I've tried multiple variations of Force New Page (before, after,
both) and New Row or Col (before, after, both) on both the group header and
the detail header.

Nothing seems to work. I have it so each year starts on a new column, but I
want each year to start on a new page.

?

 

[Duane Hookom]

I would probably create a main report based on just the unique years. Then
create a multi-column subreport that displays across then down to show the
detail information. Add the subreport to the detail section of the main
report and set each detail (year) to display on a new page.