• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 8. USING QUERIES TO GET THE MOST... > USING ADVANCED QUERY OPERATIONS

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.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint