How to make all records print twice in a single report

[Happy YN]

I want to print all records twice in one report. I.e. have 50 or so records print across the page (takes about 2 pages) and then have them starting on a new page all over again but the second time I want to miss out a field (or make it invisible). I want to have a different footer for those repeat pages. How is the best way to go about it?
Thanks

 

[llkhoutx]

One way is to save your report recordsource in a temporary table, then use a union query of your report recordsource and the temporay table as the report record source. Be sure to sort the union query.

 

[Happy YN]

That would give me no control over when to start a new page for the second lot or the propeties of some of the fields etc. I feel I need to control this from within the report
Thanks

 

[llkhoutx]

Just print 2 reports, or more to keep your pages collated.

 

[Happy YN]

Thanks for quick response. I thought of two reports but then I want the pages to be numbered 1234 not 1212

 

[llkhoutx]

You can set the page number. Look in Help.

 

[Happy YN]

seems clumsy especially since you never know the number of pages its going to turn out to be. I'm sure one can do it by putting the same field name twice in the report but I want the records to run through once and then a second time
Thanks