F. Scott Barker's Microsoft® Access 2000 Power Programming

USING ADVANCED QUERY OPERATIONS

Select and Action queries are quite useful and can answer many problems you face. Often, however, you must summarize records from a table in order to provide a reasonable amount of information to show on a form or report. By nesting queries atop each other, using subselect statements, and capitalizing on some of the more advanced features of Access, you can really tap the power of queries.

Some Summary Queries

Summary queries (often called total queries) allow you to total groups of records and do some statistics on the values. To create a summary query, use the View menu's Totals command while in the query design grid.

Note

You can combine total queries with Append or Make Table queries. They can't be used with ...