View query components

  • Thread starter Thread starter Todd
  • Start date Start date
T

Todd

Is there a way to view a list of all queries in a database
that includes which tables and queries are part of the
query?

I want to delete old queries that I no longer use, but I
don't want to affect other queries.

Same question goes for reports.
 
Todd said:
Is there a way to view a list of all queries in a database
that includes which tables and queries are part of the
query?

I want to delete old queries that I no longer use, but I
don't want to affect other queries.

Same question goes for reports.
Click to expand...

Todd,
Check out
Tools + Analyze + Documenter

Select the Options you wish to see.

The Query SQL will show what tables are used, and for a Report, the
RecordSource property will show the table/query used.

Be aware, that if a query is the basis for a another query or a report,
you'll also need to check the underlying query for which tables are
used.
 
Back
Top