Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 382
  • Last Modified:

How Do You Change the Query Attached to a Report?

How Do You Change the Query Attached to a Report?

I'm working on a system developed by someone else entirely in MS Access.  I've done a little in Access here and there over the years, but I am not familiar with all the things going on in this particular system.

The system includes about 20 reports.  If I understand correctly, reports are tied to tables via queries.  How can I disconnect a report from one query and attach it to another?  Just wondering how this works.

Thanks.
0
Danimal
Asked:
Danimal
  • 4
  • 3
1 Solution
 
kenspencerCommented:
Hi,

If you open a report in Design mode and look at the RecordSource property of the form, it will indicate what table/query it is bound to.

Ken
0
 
cjswimmerCommented:
Open the Database window (press F11) and click on the Reports tab.  select the report that you want to edit and click the Design button.  Doubleclick the little square at the intersection of the rulers along the report's edge and the properties for the report should pop up.  Click the Data tab in this dialog box and the first property 'Record Source' will display what query (or table) the report pulls its information from.  You can use the dropdown box to the right of the value to select another table or query, or you can press the button with three dots to make an SQL statement that will be used for this report.  If you use the SQL statement, you can save it from the query design screen and the report will automatically change the recordsource to the name of the query you just saved.  Please let me know if ou need any further information.  
0
 
cjswimmerCommented:
doh!  too slow
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
DanimalAuthor Commented:
kenspencer, I opened a report in Design Mode, but could not find the "RecordSource property of the form."  This does sound like what I am looking for.  Can you tell me how to see the "RecordSource property of the form?"  I will be psyched!

Thanks.
0
 
cjswimmerCommented:
you can follow the directions I posted to get to that property.
0
 
DanimalAuthor Commented:
cjswimmer!  Perfect answer!  You are da MAN!  

Thanks dude...

Stick around..I am new to VBA/Access...need to get something done that I am getting paid to do by the hour.  I got to get throught this stuff quick...but much of it is new to me.  I have dabbled in Access before, but VBA is new..

THERE WILL BE POINTS APLENTY!!!!!!!!
0
 
cjswimmerCommented:
kenspencer, I'll post a 15 point question to split the points with you, since you posted first.  Here's the link:
http://www.experts-exchange.com/jsp/qManageQuestion.jsp?ta=msaccess&qid=20145371

Danimal - glad I could help
0
 
DanimalAuthor Commented:
very cool..point sharing.

listen, I am serious when I say I have points to give away.  I'll admit to opening this round of questions with a small number on the table (i.e., 35), but I'll double the points on any future question that is answered within 2 business hours (9 AM - midnight EDT, weekends/holidays excluded).

0

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

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

  • 4
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now