Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

how do you repeat the first column (field) on a multi-page report

1 view
Skip to first unread message

JJ

unread,
Jan 5, 2010, 5:38:01 PM1/5/10
to
In a multi-page report, how do you repeat the first column of information
like you can do in Excel by simply choosing column to repeat????

Duane Hookom

unread,
Jan 5, 2010, 5:45:01 PM1/5/10
to
If I understand you correctly there isn't a clear method. You can copy the
leftmost controls and paste them just to the right of the vertical page break.

--
Duane Hookom
Microsoft Access MVP

Marshall Barton

unread,
Jan 6, 2010, 8:55:38 AM1/6/10
to
JJ wrote:

>In a multi-page report, how do you repeat the first column of information
>like you can do in Excel by simply choosing column to repeat????


I've always done that ising this sort of idea:

http://support.microsoft.com/kb/210044

--
Marsh
MVP [MS Access]

Duane Hookom

unread,
Jan 6, 2010, 9:53:01 AM1/6/10
to
I was assuming the report was too wide to fit on a single page. For instance
a report like a monthly budget crosstab with a category down the left side
and 12 columns for the months. If each column is 1" wide, this would be 12"
plus the width of the category.

If the report design wants to print the category and 1st six months on one
page and then the category and 2nd six months, then I have always moved the
last six months further to the right and inserted a copy of the categories
between months six and seven.

--
Duane Hookom
Microsoft Access MVP


"Marshall Barton" wrote:

> .
>

Marshall Barton

unread,
Jan 6, 2010, 12:21:26 PM1/6/10
to
Duane Hookom wrote:

>I was assuming the report was too wide to fit on a single page. For instance
>a report like a monthly budget crosstab with a category down the left side
>and 12 columns for the months. If each column is 1" wide, this would be 12"
>plus the width of the category.
>
>If the report design wants to print the category and 1st six months on one
>page and then the category and 2nd six months, then I have always moved the
>last six months further to the right and inserted a copy of the categories
>between months six and seven.


That's probably a good assumption. I was only thinking of a
multi column report with labels or a field repeating on each
page.

0 new messages