Create a filter

  1. Click the Advanced Filter icon on the toolbar.
  2. On the Advance Filter window, specify this information:
    Field
    Select a field from the list.

    The field that you select serves as the category on which your filter is based.

    Condition
    Select a condition from the list.
    • = displays only records that contain the exact value that you specify.
    • != displays only records that do not contain the exact value that you specify.
    • Like displays records that contain a similar value to the value that you specify.
    • Not Like displays records the do not contain a similar value to the value that you specify.
    Value
    Specify a value. The value serves as the basis of your filter results.

    For example, if the field is Collection, the condition is =, and the value is Summer, your filter results display only records that are included in the Summer Collection.

  3. Click Add.
  4. To add more conditions, repeat steps 2 and 3.
  5. To define the relationship of the conditions, select AND or OR.
    • AND combines all conditions to filter records.
    • OR filters records using any of the conditions that you specify.
  6. Optionally, click Remove to delete added conditions.
  7. Click Filter.
    Your filter is automatically saved as Recent Filter.
  8. Click Close.