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