Usually when you define a
Select command, you want to add filter conditions to restrict the rows retrieved.
To add simple search conditions on the columns in a query:
- Open the query.
- Click the
Conditions row of one of the columns.
- Type in a value that the column should match. For example, under the ST column, enter the values DC, MD, and VA on separate
rows. Quotes appear around the values if they are needed. The three values are treated as OR conditions.
Note: If you want to compare a column with another field, you will use the join mechanism.