The name of the table from which records are retrieved. The name of the field or fields to be retrieved along with any field-name aliases, SQL aggregate functions, selection predicates (ALL, DISTINCT, DISTINCTROW, or TOP), or other SELECT statement options. SyntaxĪ SELECT statement containing a GROUP BY clause has these parts: A summary value is created for each record if you include an SQL aggregate function, such as Sum or Count, in the SELECT statement. The GROUP BY clause in Access combines records with identical values in the specified field list into a single record. Access for Microsoft 365 Access 2021 Access 2019 Access 2016 Access 2013 Access 2010 Access 2007 More.
