Setting Page numbers on copies of a report

  • Thread starter Thread starter Will
  • Start date Start date
W

Will

I have a 1 page report which I want to print numerous copies of. The number
of copies will be specified by the user. My problem is that I want each
report to print the copy number of number of copies, e.g. 1 of 6. I can set
the report so the report prompts the user for the copy number and the number
of copies but this means they have to enter 1 then 6 then print, 2 then 6
print etc. How can I set it so that when the report is opened it asks for
how many copies/pages and then prints copy/page number and total copy/page
number on each page?

thanks

Will
 
Will said:
I have a 1 page report which I want to print numerous copies of. The number
of copies will be specified by the user. My problem is that I want each
report to print the copy number of number of copies, e.g. 1 of 6. I can set
the report so the report prompts the user for the copy number and the number
of copies but this means they have to enter 1 then 6 then print, 2 then 6
print etc. How can I set it so that when the report is opened it asks for
how many copies/pages and then prints copy/page number and total copy/page
number on each page?
Click to expand...


Create a table, let's name it Numbers, with one field, which
I'll call Num. Populate the records with sequential numbers
from 1 to a reasonably large number.

Now, change the report record source to query along these
lines:

SELECT Numbers.Num, yourtable.f1, yourtable.f2, . . .
FROM Numbers, yourtable
WHERE Num < [Enter number of Copies]
AND yourtable.PK = [Enter CustomerID]

Note: it's better to use a form to specify the query
parameters instead of popup prompts, but that's a different
question.

Now, change the report's design to group on the Num field
using the Sorting and Grouping window (View menu). Specify
Yes for the group header section.

The report can then refer to the Num field to display the
copy number and the parameter for the number of copies.
E.g. a group header text box could use an expression like:

="Copy " & Num & " of " & [Enter number of Copies]
 
Back
Top