> This does work just as I thought. Now the problem that I encounter is when
>trying to export this report to a FoxPro table, I lose all of the information
>in the subreport. Any suggestions?

You mean besides 'don't do that'? :-) If you're trying to export it to a table, you're probably better off doing it in VFP, even if it does duplicate some work you do in Crystal: UNION the two SELECT statements, if you absolutely have to have them in the same table.....