3 Identical Reports (almost)

[Paul Wagstaff]

Hi Folks,

I have a report for which I need three copies - identical in every way
except each contains a label (lets call it 'lblReportInstance') with a
caption saying "Part 1", "Part 2" and "Part 3" respectively.

At the moment I have 3 separate reports that I run sequentially and output
as snapshot files. Can someone suggest a swifter method?

Thanks,
Paul.

[Wayne Gillespie]

On Wed, 15 Feb 2006 22:04:14 GMT, "Paul Wagstaff"
<pa**********@blueyonder.co.uk> wrote:

Hi Folks,

I have a report for which I need three copies - identical in every way
except each contains a label (lets call it 'lblReportInstance') with a
caption saying "Part 1", "Part 2" and "Part 3" respectively.

At the moment I have 3 separate reports that I run sequentially and output
as snapshot files. Can someone suggest a swifter method?

Thanks,
Paul.

Create a new single field (ReportInstance) table (tblReportInstance) with 3
records containing "Part 1", "Part 2" and "Part 3".

Add this table to the recordsource of the report with no joins to any other
tables. Add ReportInstance from this table as a field in the recordsource.
Add a new textbox to you report and bind it to ReportInstance.

Because ReportInstance has been added to the recordsource and Access cannot
determine any logical relationship between ReportInstance and any other field in
the RS, it will return one row for each record in tblReportInstance. The only
difference between these records will be the value of ReportInstance.
Therefore the report will print 3 pages per record labelled "Part 1", "Part 2"
and "Part 3".
Wayne Gillespie
Gosford NSW Australia