Results 1 to 10 of 10
  1. #1
    hatsufi is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    6

    Group heading in report


    I am sorting my report by 2 groups, but when I try to add a group heading at the top of the second group, it puts the same heading on top of EACH group.

  2. #2
    JoeM is offline VIP
    Windows 7 32bit Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Are you sure that you are putting it in the Group Header section and not in the Report Header section?
    Last edited by JoeM; 02-01-2018 at 11:37 AM. Reason: clarification

  3. #3
    hatsufi is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    6
    My group is called "Youth", and I have a youth header. SHould the label be in that section and how do I get a label there?

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Click on the header so the section has focus. Pull a label in from the design tab on ribbon or copy/paste.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    hatsufi is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    6
    I insert a label in the "Youth" group section, but it prints the label at the beginning of the report, and then again when the "Youth" group section starts later on the 3rd page. I would like the label only above the group where "youth" begins.

  6. #6
    hatsufi is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    6
    this is a screeshot of design
    Attached Thumbnails Attached Thumbnails Screenshot (1).jpg  

  7. #7
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    The highlighted control is a textbox? What do you mean by 'label' - group identifier?

    Does Youth field have group identifier? If you want the group identifier as header then use a textbox bound to Youth field.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  8. #8
    hatsufi is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    6
    The youth field is a check box yes/no. Maybe i need to make it something different? Here is what i have: A group of names, some of which belong to the youth group and some who don't. So i have a check box field if they belong to the youth group. Then when i print my report, i want all those names at the beginning that are not checked for youth, then the youth at the end of the report. They way i have it set up now, it does separate the youth in the report, but I would like a label at the begginning of that last group that would recognize them as "youth"

  9. #9
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Expression in textbox in the Youth group section:

    =IIf([Youth], "Youth", "Not Youth")
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  10. #10
    hatsufi is offline Novice
    Windows 10 Access 2016
    Join Date
    Feb 2018
    Posts
    6
    WOw!!! Awesome!! Just what I needed. Thank you. I did not want the first one labeled at all, so I removed "not Youth" on your expression and it works great. Thanks again for taking the time to help me!!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 3
    Last Post: 11-02-2017, 10:37 AM
  2. Replies: 3
    Last Post: 03-15-2014, 10:38 AM
  3. Report Group - Show empty Group
    By crimedog in forum Reports
    Replies: 2
    Last Post: 12-30-2013, 01:06 AM
  4. Replies: 1
    Last Post: 04-05-2013, 01:58 PM
  5. Replies: 4
    Last Post: 07-27-2012, 07:04 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums