Adding Selection Criteria to a Select Query
Although a select query displays only the fields you select, by default, it will show all of the records. By modifying the select query in Design view, you can refine the query so that it shows only records that meet specific criteria. You can also hide fields so they don't display in Datasheet view.
To specify criteria for a select query:
- In Design view, click in the criteria cell and type the value that you want all records to match.
- Run the query by clicking the Run button.
To hide a query field in Datasheet view:
- In Design View, click the Show box to remove the checkmark for the field you want to hide.
- Run the query.
Criteria expressions are not case sensitive.
Advanced query techniques are covered in tasks in the Access Advanced module.
Use comparison operators to specify criteria for fields with number, currency or date/time data types: > (greater than), < (less than), = (equal to), <> (not equal to), >= (greater than or equal to), and <= (less than or equal to). For example, the criteria >=1/1/96 will return all records with values in that field that are greater than (more recent) or equal to January 1, 1996.