Results 1 to 3 of 3
  1. #1
    emerrube is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jun 2011
    Posts
    4

    Question subreports

    Is there anyway to add specific criteria to subreports in the main report? I'll try to explain this so it makes sense.



    I'm trying to create one report from a bunch of reports for each center that needs those reports.

    It's not a problem adding the specific reports to the one report. I have that figured out, but I can't seem to figure out how I can make it specific to each center.

    I tried creating a query for the main report, but in the subreports it is still pulling all the centers and not the specific center for the report.

    Is there a way to pull the specific letters for the center designated in the main report?

    Does this make enough sense? Thanks for your help.

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,930
    The main report is filtered to just one center? Are Master/Child link properties of the subreport containers set?
    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
    emerrube is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    Jun 2011
    Posts
    4
    I finally have a chance to look at this again. They did get set. But I don't think they are right. When I opened the query I created for the letter it was moved into SQL. This database has been around awhile and I can't remember why I did that. I might just try to redo the database. It's not super complicated. Thanks for your help.

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

Similar Threads

  1. Subreports - Different
    By frousseau in forum Reports
    Replies: 1
    Last Post: 09-07-2010, 05:14 PM
  2. Using Subreports
    By jonesy29847 in forum Access
    Replies: 5
    Last Post: 04-20-2010, 11:16 AM
  3. Sumarizing Subreports
    By trop in forum Reports
    Replies: 0
    Last Post: 07-29-2009, 10:43 AM
  4. PivotGraph Subreports
    By smokeybill08 in forum Reports
    Replies: 1
    Last Post: 06-10-2009, 11:33 AM
  5. Hiding subreports
    By aouellette in forum Reports
    Replies: 0
    Last Post: 09-12-2008, 08:02 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