After you select the group field(s), click the Grouping Options button at the bottom of the dialog box to display another dialog box, which enables you to further define how your report uses the group field.

For instance, you can choose to group by only the first character of a field chosen for grouping. This means that all records with the same first character in the grouping field are included as a single group. If you group a customers table by the CustomerName, and specify to group on the first character of the CustomerName field, a group header and footer appears for the set of all customers whose name begins with the same character. There would be a group for all records with a CustomerName beginning with the
letter A, another group for all records with CustomerName beginning with the letter B, and so on.

The Grouping Options dialog box, which is displayed when you click the Grouping Options button in the lower-left corner of the Report Wizard screen, enables you to further define the grouping. This selection can
vary in importance, depending on the data type.

The Grouping intervals list box displays different values for the various data types:

• Text: Normal, 1st Letter, 2 Initial Letters, 3 Initial Letters, 4 Initial Letters, 5 Initial letters
• Numeric: Normal, 10s, 50s, 100s, 500s, 1000s, 5000s, 10000s, 50000s, 100000s
• Date: Normal, Year, Quarter, Month, Week, Day, Hour, Minute

Normal means that the grouping is on the entire field. In this example, use the entire Customer Name field. In this example, the default text-field grouping option of Normal is acceptable.

If you displayed the Grouping Options dialog box, click the OK button to return to the Grouping levels dialog box.

Click the Next button to move to the Sort order dialog box.

• More Cycling Glossary Terms A good part of understanding your triathlon training and performance is having a grasp on the lingo. Here is a...
• 50 really useful Android tips and tricks [/caption] Android is a great little mobile operating system for the modern smartphone, but it can feel a little bewildering...
• PTT Thailand Open Set to Open in Bangkok, Thailand The PTT Thailand Open is going to be a tight affair comprised of a truly fantastic group of rising stars...
• Advertising on Facebook If you are not already making use of Facebook as a method of marketing your business or niche, then you...
• The Group: Six People in Search of a Life (Paperback) Amazon.com Review "It's painful to listen to yourself, at least in the beginning, but the alternative is endless suffering," says...