In addition to creating result sets comprised of individual rows, you can create a result set that includes summary information out of information in groups of rows.
| To | See |
| Learn about creating aggregate queries to summarize and group data. | Summarizing and Grouping |
| Learn about logical principles for creating aggregate queries. | Summary and Grouping Behavior in the Query Designer |
| Create an average, sum, or other summary from information in all rows in a table. | Summarizing Values for All Rows in a Table |
| Count the number of rows that meet specific conditions. | Counting Rows in a Table |
| Create subsets of summary information by organizing data into groups. | Grouping Rows in Query Results |
| Create search conditions that apply to groups of rows. | Specifying Conditions for Groups |
| Use search conditions on both individual rows and on groups of rows. | Using HAVING and WHERE Clauses in the Same Query |
| Use calculations to create summary information. | Summarizing Values Using Custom Expressions |