Summarize Query Results (Visual Database Tools)


When you create aggregate queries, certain logical principles apply. For example, you cannot display the contents of individual rows in a summary query. The Query and View Designer helps you comply with these principles in the way the Diagram pane and Criteria pane behave.

By understanding the principles of aggregate queries and the Query and View Designer's behavior, you can create logically correct aggregate queries. The overriding principle is that aggregate queries can result only in summary information. Thus, most of the principles that follow describe the ways that you can reference individual data columns within an aggregate query.

Work with Columns in Aggregate Queries (Visual Database Tools)
Describes concepts about grouping and summarizing columns with the GROUP BY, WHERE, and HAVING clauses.

Count Rows in a Table (Visual Database Tools)
Provides steps for counting the number of rows in a table or the number of rows in a table that meet a set of criteria.

Summarize or Aggregate Values for All Rows in a Table (Visual Database Tools)
Provides steps for summarizing all rows rather than for a set of grouped rows.

Summarize or Aggregate Values Using Custom Expressions (Visual Database Tools)
Provides steps for using expressions to summarize or aggregate rather than using the predefined clauses.

Design Queries and Views How-to Topics (Visual Database Tools)
Provides links to topics covering how to use the Query and View Designer.