<

MS Access – Repeating Sub-Report Headings on Each Page

Posted on
14,514 Points
5,214 Views
8 Endorsements
Last Modified:
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

Become a Certified Penetration Testing Engineer
Become a Certified Penetration Testing Engineer

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

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 62

Author Comment

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

Jim.
0

Expert Comment

by:jared Winton
Thanks!
0
LVL 62

Author Comment

by:Jim Dettman (EE MVE)
Quite welcome.

Jim.
0

Featured Post

C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

It is not that simple from VBA to display a compressed help file as it should be. API calls and a few tricks are needed. This demo and full code will show you how.
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.

Keep in touch with Experts Exchange

Tech news and trends delivered to your inbox every month