One to many Problem

[GizmoT]

I have a report which is like an application form, which is based on a query. The query shows all records in tblCustomer and only records in tblCustPrevAddress where joined files are equal.

Problem is when a customer has more than one previous address I get two reports - one with the first previous address and one with the second previous address. How can I get the report to show BOTH addresses on one report?

Do I HAVE to create a sub-report?

 

[Pat Hartman]

Yes, use a subreport.

 

[GizmoT]

Thanks Pat. The sub-report is rather awkward to format, and I had hoped there was an easy (lazy bugger) way to do it. But I resolved myself to it, and it is done.