Microsoft Office Tutorials and References
In Depth Information
one record for each group. Aggregate functions, which appear in the other columns of the
design grid, provide statistical information for each group.
You need to modify the current query to add the Group By operator for the PositionTitle
field. This will display the statistical information grouped by position for the 64 selected
records in the query. As you did earlier, you will copy the WageStatistics query and paste
it with a new name, keeping the original query intact, to create the new query.
To copy and paste the query, and then add the PositionTitle field with
the Group By operator:
1. Right-click the WageStatistics query in the list of queries, and then click Copy on the
2. Right-click an empty area of the Database window, and then click Paste on the shortcut menu.
3. Type WageStatisticsByPosition in the Query Name text box, and then press the Enter key.
Now you’re ready to modify the query design.
4. Open the WageStatisticsByPosition query in Design view.
5. Double-click PositionTitle in the Position field list to add the field to the design grid. Group
By, which is the default option in the Total row, appears for the PositionTitle field.
You’ve completed the query changes, so you can run the query.
6. Run the query. Access displays 16 records—one for each PositionTitle group. Each record
contains the three aggregate function values and the PositionTitle field value for the group.
Again, the summary statistics represent calculations based on the 64 records selected by
the query. See Figure 3-40.
Aggregate functions grouped by PositionTitle
aggregate function results
7. Save and close the query, and then close the Northeast database.
Trouble? If a dialog box opens and asks if you want to empty the Clipboard, click the