Question on Access 2000 Report Design - Microsoft Access / VBA

New Guy

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.

Nov 13 '05 #1

Subscribe Reply

1810

Allen Browne

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.c om> wrote in message
news:sd******** *************** *********@4ax.c om...

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.

Nov 13 '05 #2

New Guy

On Mon, 11 Jul 2005 10:02:25 +0800, "Allen Browne"
<Al*********@Se eSig.Invalid> wrote:

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.

What is a subreport?

Thank you.

Nov 13 '05 #3

Allen Browne

"New Guy" <Ne****@yahoo.c om> wrote in message
news:4v******** *************** *********@4ax.c om...

What is a subreport?

Thank you.

In report design view, in the Toolbox (View menu), there's a thing called a
subreport control.

For more help, try typing that question into the Help in Access.

--
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.

Nov 13 '05 #4

Similar topics

4618

Open question - leverage all features liberally, or be selective?

by: Steve Jorgensen | last post by:

In a recent thread, RKC (correctly, I believe), took issue with my use of multiple parameters in a Property Let procedure to pass dimensional arguments on the basis that, although it works, it's not obvious how the code works if you don't know the intricacies of the Property Let/Get syntax. Likewise, I dislike (and code to minimize the use...

Microsoft Access / VBA

3122

Access 2000 query not working same as Access 97

by: Ken Lindner | last post by:

We have a report based on a query that is called from a form. Nothing too special here. The query has 3 coulmns that are populated directly from values entered into entry fields on the form that calls the report using syntax such as "StartDate: !!" in the field value of the column. This also reads as "!! AS StartDate" in the SQL design...

Microsoft Access / VBA

4614

Access 2002 Performance Issues

by: John | last post by:

Hi, I've recently upgraded from Access 97 to Access 2002 & the performance basically stinks. I have tried the following items listed below but it has only had a minor impact: 1) Upgraded Jet 4 to Service Pack 7 2) Set Subdatasheet Name to from 3) Shortened the file name of the .MDB file 4) Made sure the Track name AutoCorrect info is...

Microsoft Access / VBA

4539

Access 2000 First record of report preceeded by blank record

by: Bob | last post by:

Hi, I am using Access 2000 to print out an address book. I have designed the report based on a database whose first record is not blank. In the design there is a one line report header, a onle line page header, three lines of detail (name address etc)and a footer. On previewing or printing the report it inserts a blank three line detail...

Microsoft Access / VBA

2436

DB Design Question

by: Test User | last post by:

Hi all, (please excuse the crosspost as I'm trying to reach as many people as possible) I am somewhat familiar with Access 2000, but my latest project has me stumped. So, I defer to you experts. I've been asked to create a Daily Log sheet to be distributed to some of our clerks. For each day, the clerk is to log tasks worked on for the...

Microsoft Access / VBA

4721

Error Trapping In Access 2000

by: Peter Frost | last post by:

Please help I don't know if this is possible but what I would really like to do is to use On Error Goto to capture the code that is being executed when an error occurs. Any help would be much appreciated. Thanks in advance

Microsoft Access / VBA

1348

ACCESS 2000 Question

by: Kailey11 | last post by:

This probably is a basic question for most of you, but I am setting up an very simple database - person, date traveled, location and milage - using ACCESS 2000 and I want to add up the milage in one field so when I do a query on each person I can print out a report giving their total milage for the time period. I have been pulling out my hair...

Microsoft Access / VBA

1303

stupid report question

by: ken | last post by:

Hi, My report width is stuck at 22". I can't make it smaller. There is nothing that is interfearing with me decreasing the width...is it a bug in access 2000? Thanks

Microsoft Access / VBA

9934

Access 2002 vs. 2003

by: Neil | last post by:

We are running an Access 2000 MDB with a SQL 7 back end. Our network guy is upgrading to Windows Server 2003 and wants to upgrade Office and SQL Server at the same time. We're moving to SQL Server 2005, and, since he already has licenses for Office Pro 2002, he wants to upgrade to that. I've been saying that we need to upgrade to Access...

Microsoft Access / VBA

7736

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. ...

C / C++

7982

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...

Online Marketing

7827

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the...

General

6066

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...

Career Advice

5110

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert...

C# / C Sharp

3494

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1961

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system

C# / C Sharp

1079

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

783

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

by: bsmnconsultancy | last post by:

In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...

General