Criteria Window

This window is used in both the Statistics Tab and for some reports. It allows you to enter sort and filter criteria for the records to be returned. The only custom fields available are those established for the description tab.

A few hints:

• "ASC" means Ascending order.
• "DESC" means Descending order.
• When applied to text fields, the comparison operators (=, <, >, <>) apply to the alphanumeric sort order.
• Use the "Like" operator to find strings like the text you enter.  % is a wildcard character that can be used to match any one or more characters.

A few examples:

• Sort results by manufacturer in ascending order: 
• Sort By: Manufacturer ASC
• Sort results by the person you recieved items from (in descending order): 
• Sort By: RecName DESC
• Locate all items dispositioned to someone with a name that contains the letters 'PRYOR': 
• Filter By: DispName Like %Pryor%
• Locate all items dispositioned to Pryor and sort by ascending disposition date:
• Filter By: DispName Like %Pryor%
• Sort By:  DispDate ASC
• Locate a firearm with the serial number '9C6749'
• Filter By: SerialNo = 9C6749
• Locate a firearm by scanning it's bar code:
• Filter By:  BarCodeValue = [Scan Bar Code]

Back to Table of Contents.