draft copy of report

L

Licinio

I would like to print two copies of the same report, one of which with
a "draft" stamp on it. How is this possibile?
 
A

Allen Browne

Create a table with 2 fields like this (in table design):
CopyID Number primary key
CopyName Text

Save. Enter 2 records, like this (in datasheet view):
0
1 Draft

Now create a query using your existing table(s) needed for this report, and
add the new table as well. There should be no line joining the new table to
the others. This will give you 2 copies of every record. Output both new
fields (CopyID and CopyName.) The Copyname will be blank for the first one
and says "Draft" in the second.

Change the RecordSource property of your report to this table. Use the
Sorting And Grouping to group by the CopyID. Set this as a group header that
starts on a new page. Add the CopyName where you want it (probably in the
CopyID 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