Queries and reports

[theIThombre]

Hey Gang,

Quick question- I have a staff member who is tryiyng to find out which
queries are connected to certain reports. She is in the process of printing
up end of year fiscal reports and has no idea of which queries are connected
to one particular report.

Any help will be greatly appreciated!

 

[Jerry Whittle]

Rich Fisher's excellent Find and Replace add-in might be just the ticket. If
you register it (one of the best $37 I've ever spent), the cross-reference
report can find what queries use which reports and forms. It's also good way
to find orphan queries not linked to forms and reports..

http://www.rickworld.com/

 

[KARL DEWEY]

Use TOOLS - Analyze - Documentor. Select the reports and option Properties,
click ok, click ok. Scroll down to Record Source.

 

[BlueWolverine]

Couldn't you just go into Design mode on the report and right click on the
grey/tan box in the upper left hand corner and choose "properties" and go to
the data tab??

If your record source is a query (most likely) then it's name appears in the
top box.
(Access 2003)

 

[Klatuu]

Jerry,

I agree wholeheartedly. I have been using it for about 3 1/2 years.
I once almost quit a contract because they said I could not install any
software not purchased by the company. I told them to either buy it or
replace me. They bought it. I doubt I could count the number of times the
time savings have paid for the product.