I have a report that identifies the monthly responsibilities of each supervisor. The report is printed in the report feature of Access, and I want the page numbers to start over when the supervisor changes. Currently, the page numbers continue to increase when the supervisor changes. Any suggestions?

Also, I would like the pages to print from the last page to the first page - I have an HP 6110.

Thanks in advance,

David

David,

If you GROUP the report on supervisor and place the page number on the GROUP footer, not the report or page footer, does the numbering start over again at the next supervisor?

Also, to print backwards, I don't see any printer settings you can do via code. You'd have to do that when you manually print the document from your print dialog box.

Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

Thanks for the response. The report is grouped on Supervisor, but I did not think to try puting the page number in Supervisor footer. However, when I tried it, it only printed the footer at the end of the Supervisor's section of the report. It did not restart page numbering on the next page.

Thanks anyway. Anymore suggestions?

David

Try:

http://www.mvps.org/access/reports/rpt0013.htm

Printing Access reports in reverse order is not really feasible as the pages are generated on the fly from the beginning of the report. I believe Access would have to generate the report 50 times for a 50 page report in order to ensure that a particular page was formatted correctly. You could code a loop to do this but I don't think it would be trivial. For complex reports with grouping, printing could be extremely time consuming.

Some printers allow you to switch the output to the back, front or top depending on the printer. This is the best solution I've seen to getting lengthy reports collated as one of the outputs stacks the paper right side up and the other upside down effectively reversing the order. One of the printers I use, a HP LaserJet 2100, has this capability but it requires you to physically move the position of one of the output trays.

Ciao
Jürgen Welz
Edmonton AB Canada
[email protected]

Thanks for the advice. I'm only talking about a 130 page report, which would take my secretary only a few minutes to put it in the proper printed order. I thought perhaps Access had a feauture that would allow this to be done in design view. Evidently not. I also have an HP Series II that would do the printing properly, but I like the HP 6110 because it allows me to print the headers and footers in color, enhancing the look of the report. I guess it is one of those situations where the programming world is not perfect. I gain speed with the Series II, but lose color. I gain color with the 6110, but lose speed.

Thanks for your time,

David