Want to print multiple copies and multiple records

R

reject

I would like to print multiple copies of all records of a report. The
number of copies I want to print for each individual record varies and
is stored as a value in a table.

I originally created a single page form of a "flyer" and each new
record represents new information for a different flyer. When I am
viewing my form and I click the print icon on the menu bar, all records
print once. This is sort of what I want, but I would like to print
each record X number of times depending on my stored variable. When
searching for an answer on how to do this, I got the impression that
printing is really supposed to be done from reports rather than forms,
so I created a report based on my form. Now, I have no idea what to
do. Any help would be greatly appreciated.
 
D

Duane Hookom

Create a table [tblNums] with a single numeric field [Num] and values 1 to
the largest number you will ever need. Add this table to your report's
record source. Add the Num field to the grid and set the criteria for this
column to:
<=[my stored variable field]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top