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?