Querying for Records in a Selection Dialog Box

You can query in a selection dialog box just as you query in a list or form. Consequently, you can search for specific information from one field or from several fields at one time.

To query for records in a selection dialog box  

1. In the selection dialog box, click the Magnifying Glass icon.

   A blank row appears in the selection dialog box.

2. Enter your query criteria in the appropriate fields.

   A wildcard is automatically assumed at the end of text you enter in the query fields. If you search for Siebe, then all words beginning with the letters Siebe are found.

   If you query a data field that has a calendar select button to display the calendar control, then you must include the date field value in quotes if you execute the query without specifying a time. For more information about entering query criteria, see "Simple Query Operators".

3. Click the right-arrow-in-a-circle icon.

   The records matching your query criteria appear.