Search Conditions
The And Window allows you to further add more criteria to limit
the amount of data in your report. The following is what you should see.

There are many components to this window. Let's explain
each of them.
- Logical
This drop down menu will give you the choice of using "not." Using
not will negate everything in the Expression1 and Expression2 statements.
- Expression1 and Expression2
This is the main section of the And window. You will place
your criteria in this area. To place criteria, first place your mouse cursor on one
of the Expression menus. Select a table and field from the Table/Column,
a formula from the Formulas table, or a parameter from the Parameters
menu. Double click the field to add. The >>
button allows you to add another Expression menu row.
- Operator
This menu lists all the conditions for the criteria. Click here for a definition of each of them.
- Table/Column Menu
You can select a table and the field under in this
area and place it in the Expression menu. Just
select the table, and double click on the field.
- Formulas and Parameter
This allows you to add formulas and
parameters into the Expression
menu. Just select the field and it will be placed.

+ icon: Add numbers or fields together in the Expression
menu.
- icon: Subtract numbers or fields together in the Expression
menu.
* icon: Multiply numbers or fields together in the Expression
menu.
/ icon: Divide numbers or fields together in the Expression
menu.

= icon: Equate fields together
" icon: Place quotations on long
character strings or name that have blanks in them (example: place quotes on values like
"New York" or "Washington DC")
|| icon: Allows you to place fields together in the same Expression
menu. (example: "New York" || "Washington DC")
( ) icon: Place your fields in parentheses
- Clear
Will clear multiple Expression rows
- Delete Row
Will delete single Expression row