Viewing the underlying query for a report

G

Gil Grissom

I have a report that lists REQUIREMENTS based on a query that has a
WHERE clause limiting the results to a specific developer, say,
DEVELOPER_X. I call the Query and the Report: USER_X - REQUIREMENTS.
I then copied the Query and Report to: USER_Y - REQUIREMENTS. I
changed the WHERE clause in the query to filter on USER_Y. However, I
am wondering how to point the new report to the new query, i.e. how do
I see the underlying query for the report?
 
G

Gil Grissom

Nevermind, I found it.

For those who didn't know:

-Right-click in the design view to get a context menu
-Select Properties
-In the object listbox, select Report
-Click the All tab
-The first item is: Record Source This is another listbox with all of
the queries available.
-Select the one you want.
-Et voila!
 
G

gls858

Gil said:
I have a report that lists REQUIREMENTS based on a query that has a
WHERE clause limiting the results to a specific developer, say,
DEVELOPER_X. I call the Query and the Report: USER_X - REQUIREMENTS.
I then copied the Query and Report to: USER_Y - REQUIREMENTS. I
changed the WHERE clause in the query to filter on USER_Y. However, I
am wondering how to point the new report to the new query, i.e. how do
I see the underlying query for the report?
Click to expand...
In the properties of the report look for record source.

gls858
 
J

jahoobob

Open the report in design view. Select the properties icon (hand
holding a data sheet) and change the Record Source to USER_Y -
REQUIREMENTS.
 
Top