Simply select the field you want in your query. To sort the records in the query based on the entries in one of the fields, click in the sort box for that field and choose Ascending or Descending in the drop-down list. To filter the records based on the entries in one field, click inside the Criteria box in that field and type a filter criteria expression. The Show check box lets you hide or display a field during the query. Remove the check from the box to hide the field if desired.
Criteria are conditions that limit the selection of records.
Below are some frequently used expressions. Access runs the query and displays the results in Datasheet view. To edit your query, click on the View icon. Saving a Query Access does not automatically save queries. To save a query, open the File menu and select save.