<

Go Premium for a chance to win a PS4. Enter to Win

x

MS Access – Repeating Sub-Report Headings on Each Page

Posted on
12,797 Points
3,498 Views
8 Endorsements
Last Modified:
Experience Level: Beginner
4:09
Jim Dettman (Microsoft MVP/ 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

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

8
Comment
  • 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 58

Author Comment

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

Jim.
0
 

Expert Comment

by:jared Winton
Thanks!
0
 
LVL 58

Author Comment

by:Jim Dettman (Microsoft MVP/ EE MVE)
Quite welcome.

Jim.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Join & Write a Comment

This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month