Combining Reports

[swicklund]

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).

• 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)

[June7]

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.

[RayMilhon]

How the data is structured will determine how your reporting will work. Your explanation does not explain the data structure.