• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2161
  • Last Modified:

MS Access 2010 - Group Header repeats

I have a report with a Group header and on some pages it will show the group header at the bottom of the page with no detail records I assume because it hit the end of the page and no more detail records can be displayed...On the next page the Group header is repeated along with the detail records.

How do I force MS Access not to display a Group Header at the bottom of the page if there are no detail records to be displayed.  My settings for the group header are:
Keep Tog: Yes
Repeat Section: Yes
Force New Page: None
0
upobDaPlaya
Asked:
upobDaPlaya
  • 4
  • 3
1 Solution
 
peter57rCommented:
You need to go into your report group settings and choose one of two options that prevents orphan group headers.

Setting 'Keep together' on the group header does that but only that - keeps the group header together.
0
 
upobDaPlayaAuthor Commented:
I went to Report Header and changed it to Keep Together from Yes to No and I still have orphans ?
0
 
upobDaPlayaAuthor Commented:
When you say report group settings, are you referring to the "Group Header"...I do not see any other Group sections I can alter ?
0
The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

 
peter57rCommented:
You are in completely the wrong place.
With the report in design view click the Group/Sort option on the ribbon- the grouping details appear at the bottom of the design screen and one of those options is to keep the group together.
0
 
upobDaPlayaAuthor Commented:
Thanks that worked !  However, what is the difference between what is available on the ribbon vs when I select on the Group Header Section and then click on properties...It seems like some options are the same on the ribbon method vs selecting the group header/properties
0
 
peter57rCommented:
As I said in my first response...

Setting 'Keep together' on the group header does that but only that - keeps the group header together.

.... so it stops a multi-line group header from being split across two pages.
0
 
upobDaPlayaAuthor Commented:
Thanks...apologies for struggling on this one..but I get it now..
0

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now