Multiple Records in One Report

  • Thread starter Thread starter VainDM
  • Start date Start date
V

VainDM

Hi all i have a report that combines multiple areas of my database and puts
them in one report linked by the Product ID. However on some areas such as
Product Maintenance there are more than one record for the same product. When
the report is printed it puts these records on separate sheets. Is there any
way of setting it up so that i prints them on one page?
 
To Clarify, the Main record source for the report is Products, which
incorporates the fields <Colour> / <Material> / <Location> all of which have
one record per product. Then there are the Maintenance and Fault sub reports
that have multiple records per product.

When the report is printed each maintenance and fault record are printed on
a seperate sheet, is there any way of making them print on one sheet?
 
Back
Top