Report Numberring

G

Gerrit

Hi, I have a access report that I would like to print multiple copies of, and
the display the numbering on each copy, example 1 of 10, 2 of 10 ..... etc
Help please
 
M

Marshall Barton

Gerrit said:
Hi, I have a access report that I would like to print multiple copies of, and
the display the numbering on each copy, example 1 of 10, 2 of 10 ..... etc


Create a table (named Numbers) with one field (named Num)
and populated withe records 1,2,3,... up to more than the
greatest number of copies you will ever need.

Then modify the report's record source query to look
something like:

SELECT table.*
FROM tablem, Numbers
WHERE Num <= ]Enter number of copies]

Then add a top level group to the report and move everything
from the report header section to theis group header. Add a
text box bound to the Num field in the group header.
 

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