<

Watch MS Access – Repeating Sub-Report Headings on Each Page

Posted on
15,184 Points
5,886 Views
8 Endorsements
Last Modified:
Published
Experience Level: Beginner
4:09
Jim Dettman (EE MVE)
Independent consultant specializing in the writing of custom packages for businesses.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.

Video Steps

1. The problem with sub-reports and headings

2. Add a dummy group to the sub report using the expression =1

3. Set the “Repeat Section” property of the dummy group’s header to yes

4. Move the column headings to the dummy group’s header

8
  • 2
4 Comments

Expert Comment

by:Ruth Barnhardt
Thank you Jim.
This was perfect! Just what I needed.
I know Access very well... but these little tricks are great to have. Thanks for sharing!
0
LVL 66

Author Comment

by:Jim Dettman (EE MVE)
Glad you could use it.

Jim.
0

Expert Comment

by:jared Winton
Thanks!
0
LVL 66

Author Comment

by:Jim Dettman (EE MVE)
Quite welcome.

Jim.
0
As you can union records, you can join field values. Presented here, DJoin offers increased speed and flexibility compared to the ancient ConcatRelated and similar functions. Further, it offers better read-out of Multi-Value fields.
Listing and selecting time zones in Microsoft Access and Excel is not straight forward. In the previous article was shown how to retrieve the time zones of Windows. Here will be demonstrated how to create tables to store these and how to display and…

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month