If the 2 tables are related to each other, create a query that contains both
tables, and use it as the source for your report.
If the 2 tables are completely unrelated (i.e. you want all records form
one, and then all records from the other), you can create a UNION query
(requires understanding SQL), or you could put the 2nd one into a subreport.
To avoid the blank pages, open the report in design view, and reduce its
Width. The Width of the report must be less than the page width less the
left and right margins. For example, if you have paper 8.5" wide, with 1"
left and 1" right margins, move your controls and reduce with width to 6.5"
or less.
--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users -
http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"New Guy" <Ne****@yahoo.com> wrote in message
news:sd********************************@4ax.com...
Is it possible to use two different tables with the Report Design
Wizard? My report requires data from two different tables and I can't
figure out how to get the wizard to accept the second one.
Also, my report uses a bunch of fields which I then rearrange so that
they all fit on one page. However, Access thinks that the report is
still three pages wide and includes two blank pages where the fields
were when I added them to the report. How do I get rid of the blank
pages?
Thx.
