An expression builder with all of the components needed to make simple to very complex SQL queries. You can use this dialog box to build, view, execute, and save SQL queries.
Most of the dialog items are self-explanatory so only a few are described below.
List Possible Values
Adds all unique values for the chosen field into the drop-down list.
Set Table Joins
Displays the Join Dialog box so that you may more easily add a join to the current query.
Run
Opens a recordset using the SQL statement you entered.
Show
Displays the SQL statement you entered.
Copy
Copies the SQL query to the SQL Statement window.
Save
Creates a new query with the settings you define.