Prev: Select records based upon calculated totals
Next: Switchboard
From: Brnstorm on 9 Dec 2009 22:18
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?
--
Retired, playing around
From: Duane Hookom on 9 Dec 2009 23:14
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.

--
Duane Hookom
Microsoft Access MVP


"Brnstorm" wrote:

> 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?
> --
> Retired, playing around
From: KARL DEWEY on 10 Dec 2009 13:20
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.
--
Build a little, test a little.


"Duane Hookom" wrote:

> 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.
>
> --
> Duane Hookom
> Microsoft Access MVP
>
>
> "Brnstorm" wrote:
>
> > 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?
> > --
> > Retired, playing around
 | 
Pages: 1
Prev: Select records based upon calculated totals
Next: Switchboard