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:
To hide a query field in Datasheet view:
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. |