Connecting Tech Pros Worldwide Forums | Help | Site Map

Print 2 different reports at the same time

Greg
Guest
 
Posts: n/a
#1: Nov 12 '05
I have 2 reports that are almost the same one is for internal use and the
other is for the customer. The Internal report has a few extra fields then
the customer report. The customer report has a criteria that the Internal
report does not have so the customer will not see all the notes added for a
job. Both reports the user has to put the customer code in for the report.
How can I get this so that when they want both reports they just click a
button instead of having to open both reports and type in the same code?


Thanks,

Greg



Larry Linson
Guest
 
Posts: n/a
#2: Nov 12 '05

re: Print 2 different reports at the same time


Create a Form into which the user can enter the Customer Code, and use that
one entry to construct the Where Condition for a DoCmd.OpenReport for each
of the two reports. You'll need to remove the parameter / criterial from the
Reports' Queries, that I infer is what's being typed in now.

Larry Linson
Microsoft Access MVP

"Greg" <gknapper@itlan.net> wrote in message
news:vqddao9vunirbc@corp.supernews.com...[color=blue]
> I have 2 reports that are almost the same one is for internal use and the
> other is for the customer. The Internal report has a few extra fields[/color]
then[color=blue]
> the customer report. The customer report has a criteria that the Internal
> report does not have so the customer will not see all the notes added for[/color]
a[color=blue]
> job. Both reports the user has to put the customer code in for the[/color]
report.[color=blue]
> How can I get this so that when they want both reports they just click a
> button instead of having to open both reports and type in the same code?
>
>
> Thanks,
>
> Greg
>
>[/color]


Greg
Guest
 
Posts: n/a
#3: Nov 12 '05

re: Print 2 different reports at the same time


Thanks for the Help .........

Greg

"Greg" <gknapper@itlan.net> wrote in message
news:vqddao9vunirbc@corp.supernews.com...[color=blue]
> I have 2 reports that are almost the same one is for internal use and the
> other is for the customer. The Internal report has a few extra fields[/color]
then[color=blue]
> the customer report. The customer report has a criteria that the Internal
> report does not have so the customer will not see all the notes added for[/color]
a[color=blue]
> job. Both reports the user has to put the customer code in for the[/color]
report.[color=blue]
> How can I get this so that when they want both reports they just click a
> button instead of having to open both reports and type in the same code?
>
>
> Thanks,
>
> Greg
>
>[/color]


Closed Thread