Results 1 to 2 of 2
  1. #1
    bfryxell is offline Novice
    Windows 7 64bit Access 2013
    Join Date
    Apr 2015
    Posts
    5

    Showing a subreport only once in a report


    I have been working on a database that involves chamber music groups. I have created a report to show a specific group with members listed, etc. I have created a subreport that shows times for coachings for the group, etc. The problem is that when I put it into the report, it shows an instance of the subreport for each group member's entry in the report. Is there a way to set it so that all of the group members are shown in the report but the subreport with the coaching schedule shows only once on the report? Thanks in advance for any help with this!

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    Put subreport into report header or footer.
    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. Replies: 15
    Last Post: 04-16-2014, 01:15 PM
  2. Replies: 1
    Last Post: 04-15-2013, 10:02 AM
  3. Report and Subreport by date
    By HelpPlease in forum Reports
    Replies: 1
    Last Post: 11-14-2012, 03:04 PM
  4. Replies: 4
    Last Post: 03-14-2011, 11:12 PM
  5. Report and Subreport
    By newbie in forum Reports
    Replies: 0
    Last Post: 02-16-2010, 12:14 PM

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