Solved

See the relevant query

Posted on 2014-10-13
3
111 Views
Last Modified: 2014-10-13
Hi,
where to see the relevant query inside Access 2007 report? how to see its query? Thanks.
0
Comment
Question by:HuaMinChen
  • 2
3 Comments
 
LVL 142

Expert Comment

by:Guy Hengel [angelIII / a3]
ID: 40376695
go to the design of the report, select the Property Sheet, Data section and check the Control Source property, it shows where the data comes from. it may be a table or view as well as some query
0
 
LVL 10

Author Comment

by:HuaMinChen
ID: 40376709
Do you mean record source below? But I see there is nothing within that.
t833.png
0
 
LVL 142

Accepted Solution

by:
Guy Hengel [angelIII / a3] earned 500 total points
ID: 40376794
yes, the value starts with qryC... enlarge the properties window a bit;
so far, I can tell you it's pointing to a query inside the access db
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Turning python script into an applet 12 45
DCount with multiple criteria 3 23
Best Approach MS Access 2013 3 20
Square brackets 4 0
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
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…
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…

747 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

13 Experts available now in Live!

Get 1:1 Help Now