PC Review


Reply
Thread Tools Rate Thread

Can I join 2 report in access 2003

 
 
ChicoTellez
Guest
Posts: n/a
 
      6th Nov 2008
I have two reports:

1st report --1 page in english
2nd report--1 page in spanish

Desire result:

1 report with 2 pages to print duplex (one side english, other side in
spanish)
 
Reply With Quote
 
 
 
 
KARL DEWEY
Guest
Posts: n/a
 
      6th Nov 2008
Make them subreports in a main report.
--
KARL DEWEY
Build a little - Test a little


"ChicoTellez" wrote:

> I have two reports:
>
> 1st report --1 page in english
> 2nd report--1 page in spanish
>
> Desire result:
>
> 1 report with 2 pages to print duplex (one side english, other side in
> spanish)

 
Reply With Quote
 
ChicoTellez
Guest
Posts: n/a
 
      7th Nov 2008
Karl, thanks for you suggestion.

I tried what you said. I added a 2nd rpt as a subreport. When I run the
report it shows a blank page, all object in the report are ignored. I got a
bunch of error related to page size issues. I adjusted margin to 11 x 17 to
make the preview of the blank page. I would expect it to adjust automatic.
Any ideas?


"KARL DEWEY" wrote:

> Make them subreports in a main report.
> --
> KARL DEWEY
> Build a little - Test a little
>
>
> "ChicoTellez" wrote:
>
> > I have two reports:
> >
> > 1st report --1 page in english
> > 2nd report--1 page in spanish
> >
> > Desire result:
> >
> > 1 report with 2 pages to print duplex (one side english, other side in
> > spanish)

 
Reply With Quote
 
KARL DEWEY
Guest
Posts: n/a
 
      7th Nov 2008
>>I added a 2nd rpt as a subreport.
My suggestion was to put them BOTH as subreports in a main report. Insert
a page break between them.
--
KARL DEWEY
Build a little - Test a little


"ChicoTellez" wrote:

> Karl, thanks for you suggestion.
>
> I tried what you said. I added a 2nd rpt as a subreport. When I run the
> report it shows a blank page, all object in the report are ignored. I got a
> bunch of error related to page size issues. I adjusted margin to 11 x 17 to
> make the preview of the blank page. I would expect it to adjust automatic.
> Any ideas?
>
>
> "KARL DEWEY" wrote:
>
> > Make them subreports in a main report.
> > --
> > KARL DEWEY
> > Build a little - Test a little
> >
> >
> > "ChicoTellez" wrote:
> >
> > > I have two reports:
> > >
> > > 1st report --1 page in english
> > > 2nd report--1 page in spanish
> > >
> > > Desire result:
> > >
> > > 1 report with 2 pages to print duplex (one side english, other side in
> > > spanish)

 
Reply With Quote
 
ChicoTellez
Guest
Posts: n/a
 
      7th Nov 2008
I also tried this approach. I only print variable data, all object are gone

"KARL DEWEY" wrote:

> >>I added a 2nd rpt as a subreport.

> My suggestion was to put them BOTH as subreports in a main report. Insert
> a page break between them.
> --
> KARL DEWEY
> Build a little - Test a little
>
>
> "ChicoTellez" wrote:
>
> > Karl, thanks for you suggestion.
> >
> > I tried what you said. I added a 2nd rpt as a subreport. When I run the
> > report it shows a blank page, all object in the report are ignored. I got a
> > bunch of error related to page size issues. I adjusted margin to 11 x 17 to
> > make the preview of the blank page. I would expect it to adjust automatic.
> > Any ideas?
> >
> >
> > "KARL DEWEY" wrote:
> >
> > > Make them subreports in a main report.
> > > --
> > > KARL DEWEY
> > > Build a little - Test a little
> > >
> > >
> > > "ChicoTellez" wrote:
> > >
> > > > I have two reports:
> > > >
> > > > 1st report --1 page in english
> > > > 2nd report--1 page in spanish
> > > >
> > > > Desire result:
> > > >
> > > > 1 report with 2 pages to print duplex (one side english, other side in
> > > > spanish)

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Access 2003 INNER JOIN KC_Cheer_Coach Microsoft Access Queries 5 7th Jul 2008 07:08 AM
In Access, how do I join two tables into one report? Linda Microsoft Access Reports 2 18th Dec 2007 03:10 AM
How do you join LastNanes & FirstNames in a Access Report sharpe@interalpha.co.uk Microsoft Access 4 29th Jul 2005 03:13 PM
Unsupported Join in Access 2003 =?Utf-8?B?YW50aG9ueXNqbw==?= Microsoft Access Queries 6 29th Apr 2005 10:46 AM
Access 2003 ADP and JOIN query =?Utf-8?B?Q2h1bmdhbGlu?= Microsoft Access Queries 0 27th Dec 2004 01:15 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:52 PM.