In this tutorial, we will show you how to use a Group By clause in Microsoft Access. Groups in access can assist you in organizing the objects in your database. Group by Clause combines records with identical values in the specified field list into a single record. A rundown value is fashioned for each record if you take in an SQL aggregate function, such as Sum or Count, in the selected statement.
The Access group by clause comes after the where clause of a query and before the optional having clause in the query.