If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
print some pages in a report n times
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] |
#3
|
|||
|
|||
print some pages in a report n times
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] |
Thread Tools | |
Display Modes | |
|
|