Audio CaptionStartStop

Adding Selection Criteria to a Select Query

To specify criteria for a select query:

  1. Switch to Design view by clicking the View button on the toolbar.
  2. Select the field you want to add criteria to.
  3. Click in the Criteria cell.
  4. Type the value that you want all records to match.
  5. Run the query by clicking the Run button.

To hide a query field in Datasheet view:

  1. Switch back to Design view.
  2. Click the Show box to remove the checkmark for the field you want to hide.
  3. Run the query.

You can refine a query so that it will only return records that meet specific criteria. Switch to Design view and add the field, if necessary. Next, type the field specifications in the Criteria cell. Run the query to see the results. When you specify criteria in a select query, you know all of the records will include the same value for that field. So why show the field? Switch back to Design view and hide the field by clicking the Show button to remove the checkmark. The field is still included in the query criteria, but won't be visible in the Datasheet view next time you run the query.