Access a query behind an existing report
1 February 2012 - 12:11pm
I received a pretty extensive database from an outside source, and I'm trying to access and change a query behind an existing report within the database. Where do I look to see which query(ies) are behind the report?
Any help would be appreciated
T_Van
15 February 2012 - 6:02pm
#1
1 go to your report, enter design view.
2 right click on the report, and select report properties
3 if not highlighted, click the Data tab on the properties window that comes up.
4 the top line should be "record source" click the button in that line that has the three dots, and it will open the query in design view.
(the explanation above presumes that all the report data comes from one report)