Solved

Change MS Access query name used by report

Posted on 2007-11-27
4
2,340 Views
Last Modified: 2013-11-28
I have changed the query name that is used by a report.  How do I get the report to look at the new query.  I don't want to re create the report.
0
Comment
Question by:JuliD
  • 2
  • 2
4 Comments
 
LVL 65

Expert Comment

by:Jim Horn
Comment Utility
Go into Design View of the report, right-click:Properties, and eyeball/change the Record Source property to be yoru new query name.
0
 

Author Comment

by:JuliD
Comment Utility
OK, I'm in Design View, where do I right click to get Record Source so that I can change it?
0
 
LVL 65

Accepted Solution

by:
Jim Horn earned 300 total points
Comment Utility
>where do I right click to get Record Source so that I can change it?
Eyeball the little grey box in the upper left of your report, then right-click:Properties
0
 

Author Closing Comment

by:JuliD
Comment Utility
Thanks!  I knew it could be done - just couldn't remember how!  
0

Featured Post

Highfive Gives IT Their Time Back

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

Join & Write a Comment

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

771 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

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now