You can use search criteria to restrict the number of rows returned by a query.
For details about the particular steps to creating search criteria, refer to the topics listed in the following table.
Explains how to enter text, numbers, dates, or logical values.
Explains the concepts behind using the AND and OR operators.
Explains the basics of choosing search criteria to get just the data you want.
Explains how to create multiple search conditions to the same data column.
Explains how to include several data columns as part of the search condition for a query.
Explains how to have only a given number or percentage of rows returned.
Explains how and why to use both of these clauses in a query.
Explains how to return all rows where the value of a give column does not match the value you provide in the query statement.
Explains the concepts behind clauses and operators used in queries.
Explains how to filter duplicate rows out of Select queries.
Explains why and how to use the AND operator to filter query results.
Explains why and how to use the OR operator to filter query results.
Explains how to create subqueries, or nested queries.
Provides links to topics with steps for the most common querying tasks.
Provides links to topics explaining the supported query types.
Provides links to topics with steps for sorting and grouping the results of a query.
Provides links to topics with steps for summarizing results, including NULL and Nonnumeric columns.
Provides links to topics and sections covering work you can do in queries and views using the Query and View Designer.