Mike:

Thanks for the tip. I've been away doing Powerbuilder programming for the last couple of years and forgot some of the Foxpro tricks. You jogged my memory enough to get this to work correctly.

Thanks!
Tom.

>One way: Create a select statement to gather the first set of data and add a dummy variable called 'PART' and provide a default value of '1'. Create a second select statement from the second set of data and create the same variable called 'PART' and provide a default value of '2'. Union the two select statements and sort first by your report criteria (customer id?) and then by part. In your detail fields use statements like IIF(PART='1',...) or IIF(PART='2'... Add GROUPS to the report on PART within CUSTOMER. Should print in the detail section all the PART='1' records first, then all the Part='2' records. In the part footer you can put separator lines, spaces, etc. Do your total in the CUSTOMER footer.
>
>HTH