print each record twice on a page

  • Thread starter Thread starter Brnstorm
  • Start date Start date
B

Brnstorm

I am trying to set up a report to fill in a 1099 form. It requires each
record to be printed out twice on each page of the form. I can't figure out
how to accomplish that. Suggestions?
 
You could make the form twice as tall and duplicate all the controls so there
are two sets in the detail section. Otherwise you can add any table or query
that returns exactly 2 records to the report's record source query. I
generally like to create a table tblNums with a numeric field Num and values
from 1 to whatever. You can add this table to your record source and set the
criteria under the Num field to Between 1 and 2.
 
I think Duane's first suggestion is the easiest but you could also use your
query and create a UNION ALL so the same record is outputted twice.
 
Back
Top