Specify Search Criteria (Visual Database Tools)

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.

In This Section

• Rules for Entering Search Values (Visual Database Tools)
  Explains how to enter text, numbers, dates, or logical values.

• Conventions for Combining Search Conditions in the Criteria Pane (Visual Database Tools)
  Explains the concepts behind using the AND and OR operators.

• Specify Search Conditions (Visual Database Tools)
  Explains the basics of choosing search criteria to get just the data you want.

• Specify Multiple Search Conditions for One Column (Visual Database Tools)
  Explains how to create multiple search conditions to the same data column.

• Specify Multiple Search Conditions for Multiple Columns (Visual Database Tools)
  Explains how to include several data columns as part of the search condition for a query.

• Specify the TOP Clause in Queries (Visual Database Tools)
  Explains how to have only a given number or percentage of rows returned.

• Use HAVING and WHERE Clauses in the Same Query (Visual Database Tools)
  Explains how and why to use both of these clauses in a query.

• Select Rows That Do Not Match a Value (Visual Database Tools)
  Explains how to return all rows where the value of a give column does not match the value you provide in the query statement.

• Include or Exclude Rows (Visual Database Tools)
  Explains the concepts behind clauses and operators used in queries.

• Exclude Duplicate Rows (Visual Database Tools)
  Explains how to filter duplicate rows out of Select queries.

• Combine Conditions When AND Has Precedence (Visual Database Tools)
  Explains why and how to use the AND operator to filter query results.

• Combine Conditions When OR Has Precedence (Visual Database Tools)
  Explains why and how to use the OR operator to filter query results.

• Create Subqueries (Visual Database Tools)
  Explains how to create subqueries, or nested queries.

Related Sections

• Perform Basic Operations with Queries (Visual Database Tools)
  Provides links to topics with steps for the most common querying tasks.

• Types of Queries (Visual Database Tools)
  Provides links to topics explaining the supported query types.

• Sort and Group Query Results (Visual Database Tools)
  Provides links to topics with steps for sorting and grouping the results of a query.

• Summarize Query Results (Visual Database Tools)
  Provides links to topics with steps for summarizing results, including NULL and Nonnumeric columns.

• Design Queries and Views How-to Topics (Visual Database Tools)
  Provides links to topics and sections covering work you can do in queries and views using the Query and View Designer.