Viewing the underlying query for a report

[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?

 

[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!

 

[gls858]

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?

In the properties of the report look for record source.

gls858