[Solved] Repeat fields on more than one page

[dreamquartz]

Hi All,

I am trying to produce a simple 2 page report where on the front and the back the same persons are listed.
The report is the same as inviewtopic.php?t=111803.
I need to be able to repeat the column "Surname, GivenName" and then print the report double sided.
This column can hold between 1 and 12 records.

I have scoured the interweb, but have come up empty.

Any guidance is appreciated.

Dream

[Villeroy]

to be stored in "direct SQL mode":

Code: Select all

SELECT <column list>, 1 AS "Page" FROM "Somewhere"
UNION ALL SELECT <column list>, 2 AS "Page" FROM "Somewhere"

[dreamquartz]

Thank you so much. that works great.