10-Unique Pages from Each Record

[Paul Engel]

I am a bit stumped. I have to print 10 different cover sheets for each
member of my database. When I had to do the same thing for a previous job,
with only 3 pages, I managed to fit all 3 on one report design page w/ page
breaks. I simply repeated the data elements on each page and created the
unique label on each. No problem.

W/ 10-pages, though, I can't get the report design view longer than 25" so I
can build the next 7 pages. Plus, it seems like a counter-productive manner
to design a report in Access...w/ the same fields in the same locations for
each page, but having to paint them on the design view each time.

I'm I thinking inside the wrong box? Is there an easy way to set up a page
w/ the static data and tell the report to print 10 times, substituting the
appropriate labels for each page? Or a hard way? Any way?

Here's what it would look like, w/ the dashed lines indicating page breaks.
The CAPS are literals, the all lower case are values from the record:

name

ssn

dob

DOCUMENT 1
--------------------------------------
name

ssn

dob

DOCUMENT 2
--------------------------------------
name

ssn

dob

DOCUMENT 3
--------------------------------------
name

ssn

dob

DOCUMENT 4

 

[Paul Engel]

DUH! I figured out one way of doing this. I have put the "data" part of the
report in the header. Then, I just use a tiny piece of the design view for
my literal and insert a page break. 10-page report only takes only 8 inches
of my design view.

I would be interested in other approaches, though.

Thanks,
Paul

 

[Allen Browne]

Paul, if you had a list of 10 subjects, and needed "English", "Maths",
"Science", etc. printed on each sheet for each person in your database, a
Cartesian product would be useful.

1. Create a table of subjects (10 records, with the names of the subjects).

2. Create a query combining the Subject table and your Member table. In
query design view, if you see any line joining the 2 tables, delete it: the
lack of any join causes a record for every combination.

3. Create a report based on this table, and lay out the detail section
however you want the results printed.

 

[RBM]

I had made a single report that printed out 8 separate
pages with 2 "reports" on each page. This was to print
out 16 pairing slips for a tournament (the 8 pages would
be cut in half to give you the 16 slips.
To do this, I had the single report with 4 subreports;
each subreport consisted of 2 pairing slips, a page break
and 2 more pairing slips.

The main report looked kind of like this:

----------------------------
Subreport1
----------------------------
Subreport2
----------------------------
Subreport3
----------------------------
Subreport4
----------------------------

Each subreport was like this:

x1x1x1x1__ y1y1y1y1y1 __ etc, etc
(remained of data on slip 1)

x2x2x2x2__ y2y2y2y2y2 __ etc, etc
(remained of data on slip 2)

--------- page break --------------
x3x3x3x3__ y3y3y3y3y3 __ etc, etc
(remained of data on slip 3)

x4x4x4x4__ y4y4y4y4y4 __ etc, etc
(remained of data on slip 4)


So,each subreport was less than 16" (2 8.5x11 pages)
The final report was 8 8.5x11 pages

Hope this helps (it might not be the best solution for you
predicament, but sure helped me)

 

[Paul Engel]

That's EXACTLY what I was looking for. Thanks!

Regards,
Paul

 

[Paul Engel]

Allen,

Some how my reply to your message got attached to another reply. This
message was to you:

That's EXACTLY what I was looking for. Thanks!

Regards,
Paul