Microsoft Access GROUP BY Query

It’s one of the simplest and most direct ways to access and control your data.

Start Access and open your database.

This example uses theNorthwind Sample Database.

Mihailomilovanovic / Getty Images

In the Queries group, selectQuery Design.

In theAdd Tableslist, pick the table you want to work with.

SelectViewin the Results group and chooseSQL View.

The main body will switch to a query terminal window.

Here, it’s possible for you to enter any query you like.

You write the query and specify that the database should group the results based upon the Salesperson field.

You may then use any of the SQL aggregate functions to perform calculations on the results.

Here’s an example.