Searching on Data Elements

B

Bunky

I have a raft of different queries that are all in a Production state. My
upper management has made some decisions that will necesitate me changing
some of these queries. The problem is how can I easily locate all queries
that use a certain element of a certain table? I really would hate to have
to go through all the queries manually as I probably would miss one.

Thank you for your assistance!
Kent
 
K

KARL DEWEY

Click on menu TOOLS - Analyze - Documenter and select all queries. In
options select SQL, run, and then analyze in Word. Search for the
table/field name.
 
B

Bunky

Super! I knew there must be a way!

Thanks

KARL DEWEY said:
Click on menu TOOLS - Analyze - Documenter and select all queries. In
options select SQL, run, and then analyze in Word. Search for the
table/field name.
Click to expand...
 
Top