Summary

This discussion began by creating a Select Query that combined several Tables by matching their Keys. We used that Query as the Record Source for the Subreport.

 

The Subreport was designed as a Table. We used the Report Arrange options to Insert Rows, Merge Cells and Move Fields into different Rows.

 

We had to Resize the Subreport and format the Headers to fit a 2" layout.

Finally, we linked the Form and Subform by a Key Field, ReceiptID.

 

You done real good. Go get the cookies!