title: Generate MS Access report that includes multiple tables/queries
body: <p>Im using Access 2007 to import statistics (Excel) from multiple units within a department. Although they share similar fields, each Unit has it's own table because they also have unit specific data/fields that needs to be tracked.</p>
  
  <p>Table:UnitA -(Fields:Date,Cars, Boats, Tags, Guns, Missing Persons, etc.)</p>
  
  <p>Table:UnitB -(Fields:Date,Cars, Boats, Tags, Guns, Bench Warrants, etc.)</p>
  
  <p>Table:UnitC -(Fields:Date, Cars, Boats, Tags, Guns, Fingerprints, etc.)</p>
  
  <p>I need to create a summary report that queries a START DATE and END DATE and then produces a report that will display:</p>
  
  <p>Sums of each of the individual fields from each record ie Sum([Fingerprints])
  Sums of each of the shared fields from each record ie Sum([UnitA!Cars]) + Sum([UnitB!Cars]) etc.</p>
  
  <p>I can create a report for each individual unit without any problems.</p>
  
  <p>My problem begins when I ceate three Unit reports and try to use subreports. Access will prompt me for new Start Dates and End Dates.</p>
  
  <p>Does anyone have a better solution? Should I create a "prompt" form that includes a Start Date and End Date field that can be accessed from within each query?</p>