4TOPS Query Tree Editor is an Access add-in indispensable for developers who use queries as the core of their applications. Keep track of the dependency relations between queries. Find the reason when a query does not return required results. Includes a powerful Query Editor. Single user $99 Order Download

The Query Tree dialog displays the dependency tree of the selected query. The buttons on the dialogs support a natural way of working with queries, smoothly switching from the tree overview to query editing to saving different versions or running them to evaluate the results. Double-click on a query opens the query datasheet. Press the Edit button to make required changes using the Query Editor. The Print button writes the tree to the Debug Window. Use it to compare query dependency trees or to paste it into your documentation. Double-click on multiple queries to compare results. This will help you diagnose in case queries dont return the results you expected. Features: Open: show what the selected query results are. Open several queries at the same time to see how the data combine.
Design: open query in Access query builder.
Edit: start the special Query Editor
Print: prints the tree to the debug window including the description of the queries an tables.
Start with Find puts an asterisk (*) in front of each query or table containing the selected field or string.
Starting from form or report picks up underlying query.

Query Used By shows in a tree all queries that depend on a certain table or query. Very helpful when assessing the consequences of changes.


Query Editor makes changes to the query easy. Replaces Access built-in editor. No need to copy to WordPad and back. Find/Replace: quickly find strings or fields, optionally replace them.
Insert Fields from a selection list
Save changes under a different name.
On opening the editor adds line breaks and indentation to the query to show its structure.