Solved

How To Change Query Source Of Existing Report?

Posted on 2006-06-26
3
326 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

In earlier versions of Windows (XP and before), you could drag a database to the taskbar, where it would appear as a taskbar icon to open that database.  This article shows how to recreate this functionality in Windows 7 through 10.
This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…

726 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