|
|
The search dialog works by letting you build up complex queries from simple ones. A simple query contains three parts; a fieldname, an operator and a value. Clicking the dropdown arrow in the Field combo box displays a picklist of all the fields in the current database table (some of which can be quite cryptic!) Choose the field on which you want to search. The second part is a list of operators, such as "Greater Than", "Equals", "Begins with" etc. Note that numeric values should be compared with "Equals" but text values should use "Like". The third part is the value to which you want to compare the field. Clicking the dropdown arrow displays a list of all the unique values of this field in the database. You can either select from the list or type directly into the text part of the control. Once you have built your simple query press the "Add" button to add it to the frame in the bottom half of the dialog. You can then either press the Find button to search for the first record meeting your criterion or add another criterion, joining the two with "And" or "Or". Keep pressing the Find Next button to move to subsequent records, until you get a message saying that no more records meet your criteria. |
|
© 1999 Energico Associates Ltd |