Combines records with identical values in the specified field list into a single record. A summary value is created for each record if you include an [SQL aggregate ...

A SELECT statement containing these predicates has the following parts. - **ALL**: Assumed if you don't include one of the predicates. The Microsoft Access database engine selects all of the records ...