Results 1 to 3 of 3
  1. #1
    swicklund is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2009
    Posts
    24

    Combining Reports


    I am setting up a database that is being used develop a Maintenance Schedule for various projects. Some specifics include:
    • I have started by setting up the maintenance schedules for individual components (there are more than 50 components), and have created a report for each of the components.
    • A Project will consist of several components (each component identified by a specific line item # within the project). I have set up a form to enter the Main Project Information, with a sub form (linked by Project_Number) to enter the Item_Number & select the Component from a Drop Down Box (see picture below).



    Click image for larger version. 

Name:	Access_Form.jpg 
Views:	15 
Size:	51.9 KB 
ID:	12693

    • Once all of the components are entered for a project, I would like to be able to print the full Maintenance Schedule for the project including:
      • A Maintenance Schedule for each Line Item entered
      • The Project Information & Item_Number should be on the top of each Individual Schedule
      • The same component can show up multiple times with a different Item_Number

    • I am thinking that I will need to us sub-reports somehow, but am not sure how to make it work (the full Maintenance Schedule could have only one (1) component, or could have as over 30 components).


    I would appreciate any help that can be provided, and if I need further information on what I am trying to do, just ask.

    I am using Access 2010 (32 bit)

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,632
    Yes, subreports can be helpful in may situations, especially when several 'many' related tables must be reported for the same parent. However, can't offer specifics for yours because just don't know your db.
    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
    RayMilhon is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    Aug 2011
    Location
    Southern California
    Posts
    1,085
    How the data is structured will determine how your reporting will work. Your explanation does not explain the data structure.

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

Similar Threads

  1. Convert Client Reports to Web Reports
    By need_help12 in forum Reports
    Replies: 0
    Last Post: 05-08-2012, 08:22 AM
  2. combining reports
    By TahaSarhan in forum Reports
    Replies: 9
    Last Post: 10-14-2011, 11:53 AM
  3. Combining first and last name
    By JRINC in forum Forms
    Replies: 3
    Last Post: 09-27-2011, 01:18 PM
  4. Reports w/ sub-reports very slow to open
    By vaikz in forum Reports
    Replies: 2
    Last Post: 02-27-2011, 08:41 AM
  5. Access Reports drop sub-reports
    By Kevin Ellis in forum Reports
    Replies: 0
    Last Post: 11-19-2010, 03:28 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