Complex printing question

Is there a way (code, plugin, etc.) to output a single Access report
as multiple reports? Preferrably, I want to control the output target
by data in the record group.
>
The scenario is this: We have a 500 page report that encompasses all
of our clients. We need to automatically deliver reports by-client to
specific printers. Other than outputting 1st to PDF, then manually re-
printing "pages n..n+5" or whatever, we do not have a way.
>
thanks
joel
>

Open the report filtered by client or group of clients and send it to the
required printer. Do this once for each destination printer. I understand
new version of Access have a printer object that will allow you to switch
printers using VB code, someone else will need to help you with that.
>
"joel@" <joelcrains...@gmail.comwrote in message
>
news:1178203953.446940.205720@y80g2000hsf.googlegr oups.com...
>
>
>>>>
- Show quoted text -

On May 3, 12:26 pm, "paii, Ron" <p...@packairinc.comwrote:

>
>
>
This is the way we are running it now. The problem is we have to
manually do it once for each dest. printer. We need Access to handle
this.
>
>

"joel@" <joelcrains...@gmail.comwrote in message
>
news:1178210289.250432.71500@l77g2000hsb.googlegro ups.com...
>theunderstandswitch>>>>re->>>>
Search the user group, I recall someone asking about switching printers and
settings with some replies on how to do it. I am running Access97, so one
way would be to set the report to use the default printer and change the
default using a Windows DLL before opening the report. Another is print each
client to PDF and use the shell command to send it to the printer.