Using query forms

  1. From the main menu, search for and open a query form.
  2. On the Query page, select an operator:
    • like yields results that are similar to the value that you specify.
    • = yields the exact value that you specify.
    • > yields results that are greater than the value that you specify.
    • < yields results that are less that the value that you specify.
    • <> yields results that are greater or less than the value that you specify.
  3. Specify a value.
  4. Click Apply to generate a new sub-collection of records.
  5. Select a record from the Results list then click Close.
    Note: You can use the Search icons of the Supplier Rebate Agreement fields to open a record's corresponding query form. When you select a record using the Search icons, clicking Close returns the record as the field value in the Supplier Rebate Agreement form.
  6. Optionally, click the Additional Criteria tab.
  7. Select a criterion that serves as the basis for querying.
  8. Select an operator:
    • like yields results that are similar to the value that you specify.
    • = yields the exact value that you specify.
    • > yields results that are greater than the value that you specify.
    • < yields results that are less that the value that you specify.
    • <> yields results that are greater or less than the value that you specify.
  9. Specify a value to query.
  10. To add additional criterion, click Add
  11. Optionally, select the OR Instead Of AND With Previous Clause check box to change the relationship among criterion clauses from AND to OR.
  12. Click Apply to generate a new sub-collection of records.
  13. Select a record from the Results list then click Close.