Construct Simple Queries
 
 
 

To construct a quick query

  1. Open the Query Editor as described in To open the Query Editor.
  2. On the Quick Query tab, select a field from the Field list.
  3. Select an operator from the Operator list.
  4. Enter a value in the Value field, or click Look Up Values.

    Look Up Values returns a list of all values for the specified field from the database table, so you can select the value that you want. After selecting a value, click OK.

  5. Select one or both of the following:
  6. If you want to save the query in the current drawing for future use, click Store.
  7. Click Execute to execute the query and close the dialog box.

    A subset of records that match your query criterion are displayed in the Data View window. To return to the Query Editor to refine your query, click the Return to Query button.