10-Unique Pages from Each Record

  • Thread starter Thread starter Paul Engel
  • Start date Start date
P

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
 
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
 
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.
 
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)
 
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
 
Back
Top