LCE260 – Group, Summary and Sort Options

Objectives

To group data that logically belongs together. You will also summarize some values by group and in total.

To achieve these objectives you will complete the following:

Step 1. Build a query over the Employee file

Step 2. Group the data

Step 3. Run the query

Step 4. Sort the data

Step 5. Define Summary options

Step 6. Apply Summary options to groups

Step 7. Save the query definition

Summary

Before You Begin

You may wish to review the following topics in this guide:

• Group Your Data

• Summarize Your Data.