print some pages in a report n times

I have a report of employees by department by state. Some departments have
more than one head, I want to print each department once for each head so
that the report can then be separated and mailed to each head by the mailing
house. The report of all departments contains over 2000 pages and 390
departments with 460 heads. I would like this all in the report as the number
of heads changes from time to time. I have a field in the report that is Y
for department heads and so I can count the department heads at the time of
printing. I have also VB code that gives me the number of pages for each
department so at print time the number of pages for a department. Hope this
makes sense.
Any help is appreciated
--
John Melbourne

John Melbourne wrote:

I have a report of employees by department by state. Some departments have
more than one head, I want to print each department once for each head so
that the report can then be separated and mailed to each head by the mailing
house. The report of all departments contains over 2000 pages and 390
departments with 460 heads. I would like this all in the report as the number
of heads changes from time to time. I have a field in the report that is Y
for department heads and so I can count the department heads at the time of
printing. I have also VB code that gives me the number of pages for each
department so at print time the number of pages for a department. Hope this
makes sense.


That would be a natural consequence of how the
tables/queries you're using for the report are designed.

I don't think you will get a useful answer until you explain
the tables and their fields that are involved in the state,
department and heads along with how they relate to each
other.

--
Marsh
MVP [MS Access]

My report is from a single query which pulls together the information from
three tables and one query. Table one contains the dates for the report
period. Table two contains the department state, department code, name and
address details. Table three contains the employee number, name, address,
department code and a flag "Y" if they are a department head. The query has
the stats for each department total number of employee's, number of
department head's.
The query is sorted State, department, reverse sort department head flag [so
department heads are always at the top], and then last name first name.

I have used VBA code in the report to give me the number of pages for each
department [The Access Web by James H Brooks, Print first and last page
numbers for report group].
But now there is a requirement to print one copy of each department for each
department head.
I would like to do this in the one report if possible.
Regards,
John Melbourne

--
John Melbourne


"Marshall Barton" wrote:

John Melbourne wrote:

I have a report of employees by department by state. Some departments have
more than one head, I want to print each department once for each head so
that the report can then be separated and mailed to each head by the mailing
house. The report of all departments contains over 2000 pages and 390
departments with 460 heads. I would like this all in the report as the number
of heads changes from time to time. I have a field in the report that is Y
for department heads and so I can count the department heads at the time of
printing. I have also VB code that gives me the number of pages for each
department so at print time the number of pages for a department. Hope this
makes sense.


That would be a natural consequence of how the
tables/queries you're using for the report are designed.

I don't think you will get a useful answer until you explain
the tables and their fields that are involved in the state,
department and heads along with how they relate to each
other.

--
Marsh
MVP [MS Access]