>>I need to print a lot of text fields on a page for each record, then print a memo (when not blank) on the following page. There will also be a page header. If I make the detail band longer than the page, it tells me so and refuses to print. If I group the data so that every record is a group, and put the memo field in a group footer, the memo field prints before the detail band. Maybe I'm missing something obvious, but I can find no way to make every record print on two pages.
>
>Duplicate records:
>SELECT key,1 as listorder,field1,field..,SPACE(254) as memo From Table1 Into Cursor tmpReport UNION SELECT key,2 as listorder,"" as field1, "" as field2....,memo From Table1
>Then print group report (group by key,listorder) with each group starting new page.
This table has about 50 fields. Is there a way to get them all into the SELECT statement that is more clever than saying

SELECT keyfield, 1 as listorder, field1,field2...field10,;
field11,field12...field20,;
...
field41,field42...field50,SPACE etc.?
If not I can live with it.