Matching queries to reports

  • Thread starter Thread starter TBH
  • Start date Start date
T

TBH

Good morning,
I was handed a database with a large number of queries
and not as many reports. My feeling is that a lot of those
queries are not needed. I need to be able to match the
queries with the current reports, so I don't delete a
query that is in use.
How do I figure out what query was used to create each
report?
Thanks for any help you can supply!
Peace, TBH
 
I am on Access 97, not sure what version you are using.
Under Tools, Documenter, you can create a report that
shows all your reports. It will list the queries that are
used for the reports.

You should be careful though - a query used in a report
can be based off of other query(s). So even if a query is
not directly used in a report, it might be needed.
 
I'm using XP, but the results are the same. I found the
information I need and will heed your caution.
Thanks so much for the help!!! TBH
 
Back
Top