How do I get report to print this way?

[SteveM]

Two questions for Access 2003 > I have a report that gives employee
attendance information. There is no report header.

I want to set up printing so that, if needed, it uses both sides of a sheet
of paper to print the information for one employee, with column headings on
each side. How do you force column headings (but not the employee heading)
on each side?

I also want the report to start each employee on a new sheet of paper (not
just a new side).

I imagine the printer must be set to print double-sided, but how do you then
force the printer to a new sheet (rather than just a new side) for each
employee? Some will need both sides of a sheet, some will not.

 

[John Spencer]

Take a look at:
Duplex reports: start groups on an odd page
at:
http://allenbrowne.com/ReportDuplex.html

Where are the column headings now? If they are in a separate group header,
you can use the properties of the report to print (repeat) on each page.

If you have an employee header with the employee information and the column
headers (labels), then add another group based on the same criteria as the
employee header and move the column headers into the new group header.

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County