Wasp Barcode Inventory Control - Manual (Page 303)

InventoryControl Printable Help
18.2 Advanced Find
The Advanced Find screen allows you to search a table in the database using multiple values and
logical expressions. This screen is useful when the table you are searching contains a lot of data. You
can enter several parameters by which to filter your search.
When you use this screen, you will construct a filter, which limits the information you are searching for to
certain parameters.
Using the Advanced Find Screen:
1. From the Main screen, click the Find icon. A menu of tables from which to search appears.
2. Select what you want to search for by clicking on an option in the Find menu. In this example we
are going to search for Customers.
Note: If the table you select (Customers, Manufacturers, Items, etc.) contains over 1000
pieces of data, you will automatically be taken to the Advanced Find screen. If you are not
automatically taken to the Advanced Find screen, the Find screen will appear.
3. Select the Advanced button on the Find screen. The Advanced Find screen appears.
The Advanced Find screen consists of seven input fields and a Filter Expression panel that
displays the resulting filter as you build it. These fields are described below:
 Table is used to select the table you want to search.
 Parenthesis (open and close) can be used to control the order in which criteria will be
processed. The inner most pair of parentheses in any filter expression are evaluated first.
 Field is used to select the field in the listed table to be searched.
288