Anyway to trace all sub reports & queries

  • Thread starter Thread starter Tracy
  • Start date Start date
T

Tracy

I have a report written by someone who no longer works at
my place of business. I have very little Access
experience, but I am trying to make some modifications to
her report. She has many subreports and subqueries
attached to the main report, which she runs by inputting
the criteria through a form (which I still have trouble
with). Is there anyway for me to see all the queries and
sub queries that make up the main report? I seem to be
chasing my tail.

Thanks in advance.

Tracy
 
Tracey

One approach would be to work your way backwards.

Start with the report, open in design mode. Find the property that shows
the data source for the report. It might be SQL, or a table, or a query.

Then, if you have any sub-reports, do the same for them.

Next, open the queries (or SQL) you've found so far, and inspect each of
those -- queries can use tables or other queries as their sources.

Keep tracking backwards until you are working only with tables. You've ID'd
all the sources!

Good luck

Jeff Boyce
<Access MVP>
 
Back
Top