Results 1 to 4 of 4
  1. #1
    Amandasr12 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2012
    Posts
    2

    Group title carrying forward to next group

    First of all I am new to access but have had some experience with other reporting tools, so please be gentle.
    We are having trouble with a report repeating the Group and Subgroup onto the first page of the next group. The 3rd grouping is correct, but the titles for the group appear to carry forward onto the new group. How can we correct this?

    This only happening on the first page of a new group, not any of the other pages for that group. We have checked the DB and the data is correct it just seems to be carrying the group and sub-group forward, the rest of the data is correct.


    Thanks

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    The 2nd group titles not showing at all?

    Don't know what is happening. Want to provide project for analysis? Follow instructions at bottom of my post.
    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.

  3. #3
    Amandasr12 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2012
    Posts
    2
    No, the Group titles show but just on the second page. For example:

    Group: Academic Affairs
    Sub-Group: English
    Sub-Group2: Account 1
    Account 2
    Account 3

    Group:Academic Affairs (Should be Fiscal Services)
    Sub Group: English (Should be Accounting)
    Sub-Group2: Account 1 (Correct)
    Account 2 (Correct)
    Account 3 (Correct)

    Group: Fiscal Services
    Sub-Group: Purchasing
    Sub-Group2: Account 1
    Account 2
    Account 3

    Thank you for your time and assistance.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,929
    Must be something about the report structure and cannot analyze without working directly with the object.
    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.

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

Similar Threads

  1. Multiple Forms carrying forward data
    By adams.bria in forum Forms
    Replies: 5
    Last Post: 04-04-2012, 10:50 PM
  2. query group by over another group by?
    By gap in forum Queries
    Replies: 2
    Last Post: 07-04-2011, 12:59 AM
  3. Replies: 5
    Last Post: 11-29-2010, 08:16 AM
  4. Group by
    By EstesExpress in forum Queries
    Replies: 0
    Last Post: 02-26-2010, 07:52 AM
  5. columns for group detail but not group header?
    By Coolpapabell in forum Reports
    Replies: 0
    Last Post: 08-21-2009, 08:53 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