Solved

How To Change Query Source Of Existing Report?

Posted on 2006-06-26
3
318 Views
Last Modified: 2008-02-01
Would seem easy, but can't find it in any Help search.  I have an existing report created in Design View, Access 2003.  Wanted a version of it associated with a different query, so just copied the report, changed a few things.  Now I cannot find how to have it pull the data from a different query.
0
Comment
Question by:Mike Caldwell
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 54

Accepted Solution

by:
nico5038 earned 125 total points
ID: 16986565
Open the report in design mode and press the properties button (Hand with white sheet).
Now change the Controlsource property to your new query under the Data tab.

Nic;o)
0
 
LVL 1

Author Comment

by:Mike Caldwell
ID: 16987202
Perfect!  Expected it would be easy, bu darned if I could find it.   Thanks much.
0
 
LVL 54

Expert Comment

by:nico5038
ID: 16987267
Glad I could help :-)

Nic;o)
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

735 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question