I created a report that is a copy of our new membership form.  This report has two address fields, a Bill-To address and a Ship-To address.  But these two addresses reside on their own records.  So when the user enters a customer number, two records are retrieved, one record with the Shipping Address and another with the Billing Address.  When I move these addresses to the report, it creates two pages, one page with the Ship-To address field populated and the Bill-To field empty, then another page with the results reversed.

 

How can I keep the report to one page, and show both addresses on the same page of the report?

 

Thanks in advance for your time!

 

Frank