2011

To create a SQL condition, specify the link template. Specify the column to
check and the value for the column.
Build a SQL condition using this dialog box, or type a condition by choosing
Type It.
Current SQL Condition area (SQL Link Condition)
This area displays the current SQL condition. You can add, delete, or edit any
line in the condition.
Current SQL Condition list
View the current SQL condition.
If lines in the condition have been grouped, the group is indented. (Lines
in a group are evaluated before lines outside the group.)
Edit
Copy the selected line to the Condition section so you can edit it.
Group
Group the selected lines.
Select the first and last lines that you want in the group. Click Group.
When you run the query, lines inside the group are evaluated before the
rest of the condition.
Ungroup
Delete the parentheses from the selected line and from the matching ending
or beginning line of the group.
Delete
Remove the selected line from the condition.
Clear All
Remove all lines from the current SQL condition.
Condition area (SQL Link Condition)
Edit an existing line in the condition or add new lines.
To edit an existing line, select the line in the Current SQL Condition list. Edit
the information in the Condition area. Click Update.
To add a new line, select the operator (And/Or/Not). Select a column and an
operator and specify a value. Click Add Condition.
And/Or/Not options
Determine how the condition is combined with other conditions.
SQL Link Condition dialog box | 1867