Search Within a Numeric Range

Some search fields allow you to search for numeric ranges. This feature is identified by a numeric search icon next to the search field. You can use the search box or type the search syntax directly into the field.

  1. Click the numeric search icon.
  1. Enter the information for the search.
  • Between: Select to search for a single number or for any numbers contained between a set. For example, return any amounts between 100 and 500.
  • Not Between: Select to search for any numbers not contained between the set. For example, return any amounts not between 100 and 500.
  • Equal: Select to search for a single number or for any numbers contained in a set. For example, return any amounts equal to 100, 200, 300, 400, or 500.
  • Not Equal: Select to search for a single number or for numbers in a set that is not equal. For example, return any amounts not equal to 100, 200, 300, 400, or 500.
  • Greater Than: Select to search for any numbers greater than the specified number. For example, return any amounts greater than 500.
  • Greater Than or Equal: Select to search for any numbers greater than or equal to the specified number. For example, return any amounts greater than or equal to 500.
  • Less Than: Select to search for any numbers less than the specified number. For example, return any amounts less than 500.
  • Less Than or Equal: Select to search for any numbers less than or equal to the specified number. For example, return any amounts less than or equal to 500.
  • Null: Select to search for any number not within a range of values.
  • Apply: Click to apply the search parameters.
  • Cancel: Click to cancel the numeric search.
  • Include Null Values: Select to include the null options in your search results.
  • Exclusive: Select to search for only the numbers entered in the fields.
  1. Click Apply to apply the information, or Cancel to return to the normal search.

NOTE: If you enter a bad formula, it displays in red. If you still have a bad formula and click Search, it will tell you which fields have bad formulas.

 

Last updated 1/3/2020.

Copyright© 2014–2019 by Azteca Systems, LLC. All rights reserved.