Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How To Change Query Source Of Existing Report?

Posted on 2006-06-26
3
Medium Priority
?
336 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 500 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

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
We live in a world of interfaces like the one in the title picture. VBA also allows to use interfaces which offers a lot of possibilities. This article describes how to use interfaces in VBA and how to work around their bugs.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

610 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