
Signature
Duane Hookom
MS Access MVP
> I'm trying to use a report which prints out 4 5X3 cards per book entry.
> This would work fine for 8 1/2" by 14", but for the card paper I have, it
[quoted text clipped - 5 lines]
> the next series of 4 to print on the second
> page? Thank you.
Thanks for your response. It's a library card program I'm working on and
there are 4 cards per book. One for the subject, one for the title, one for
the author, and one for the shelf list number. Alot of the controls are
repeated. I blocked out 4 5X3 spaces together on one report. As far as
printing them in landscape, how could you configure Access to print 4 per
page?
> Have you considered printing them in landscape where you could get 4 per
> page? Also, we don't really have any idea how you are arriving at 4 copies.
[quoted text clipped - 9 lines]
> > the next series of 4 to print on the second
> > page? Thank you.
Duane Hookom - 10 Feb 2005 03:31 GMT
I would set up a landscape report with two columns and the detail section
the size of a single card. Create a table "tblNums" with one field "Num" and
four values 1, 2, 3, and 4. Add this table to your report's record source
and don't create any join lines. Sort and Group your report by something
other than the Num field. This will create 4 copies of each record from your
original table/query.

Signature
Duane Hookom
MS Access MVP
> Thanks for your response. It's a library card program I'm working on and
> there are 4 cards per book. One for the subject, one for the title, one
[quoted text clipped - 21 lines]
>> > the next series of 4 to print on the second
>> > page? Thank you.