- Open
Query Builder.
- In
the Query Builder, click the Conditions
tab.
- Select
a table from the upper left side of the Query Builder. If necessary, click
the plus sign to expand the list of tables.
- Select
a field from the upper right side of the Query Builder. This box displays
all fields that belong to the selected table. Double-click the field to add it to the grid at the bottom of the dialog box.
The Assign Condition dialog box opens automatically.
You can open this dialog box at any time by double-clicking a statement
in the grid.
- Select
an Operator.
- In
the Value is box, enter a value or click Browse to select a value from all existing entries
for that field.
If you selected "In" as an operator,
the values must have quotation marks around each entry.
- Select
Case Sensitive Compare if you want the capitalization
of the value used as part of the condition. By default this option is
selected.
If you are using MS SQL Server, the Case Sensitive
Compare option is not applicable. All queries are case insensitive.
- If
necessary, select Use
Value as a Literal.
- Click OK.
- To
add another condition statement, repeat steps 1–9, and then select the appropriate
connector.