Results 1 to 3 of 3
  1. #1
    Glenn_Suggs is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    72

    Grouped field header on report


    Hi all. I'm trying to display a grouped field header at the top of every page since the group may extend for many pages and I want the user to be able to tell what group they're looking at even if they open to the middle of the report. It works fine to put the group value somewhere in the page header, but this doubles up on the first page since the same value is also in the first group on the first page. So for example the first page has "Group Header 1" in the page header and "Group Header 1" also in the group header itself. How can I prevent the group header from displaying only on the first group of the first page? Thanks in advance...Glenn

  2. #2
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    Quote Originally Posted by Glenn_Suggs View Post
    Hi all. I'm trying to display a grouped field header at the top of every page since the group may extend for many pages and I want the user to be able to tell what group they're looking at even if they open to the middle of the report. It works fine to put the group value somewhere in the page header, but this doubles up on the first page since the same value is also in the first group on the first page. So for example the first page has "Group Header 1" in the page header and "Group Header 1" also in the group header itself. How can I prevent the group header from displaying only on the first group of the first page? Thanks in advance...Glenn
    Go select the group header in design view and then select the "REPEAT SECTION" property and set it to YES.

  3. #3
    Glenn_Suggs is offline Advanced Beginner
    Windows 7 64bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    72
    Thanks, Bob. That was the solution. Case closed. Again, thanks a million.

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

Similar Threads

  1. Grouped Report with Charts
    By FL_Boy in forum Reports
    Replies: 2
    Last Post: 12-21-2011, 09:27 PM
  2. How do I add a field to report header
    By jscriptor09 in forum Reports
    Replies: 3
    Last Post: 12-06-2011, 05:29 AM
  3. Replies: 1
    Last Post: 08-31-2011, 04:03 PM
  4. Report people grouped to years
    By gerhard_s in forum Reports
    Replies: 3
    Last Post: 10-01-2010, 07:59 AM
  5. Replies: 2
    Last Post: 08-25-2010, 01:42 PM

Tags for this Thread

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