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 simultaneously.

To query for records in a selection dialog box  

1. In the selection dialog box, click Query (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 after 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 Go.

   The records matching your query criteria appear.