About grouping records on text values in a report

When you group records on a field that stores text values, you can set the GroupOn property to the ranges listed in the following table. In a Microsoft Access database(.mdb), you store text values in field with a Text data type. In a Microsoft Access project (.adp), you store text values in a column with a char, varchar, nchar, or nvarchar data type. If you set the GroupOn property to Prefix Characters, you can set the GroupInterval property to any number that's valid for the value in the field you're grouping on. If you set the GroupOn property to Each Value, the GroupInterval value is 1.

Set the GroupOn property to	To group records
Each Value	That contain the same value in the field or expression.
Prefix Characters	That contain the same first n number of characters in the field or expression.

Report that groups records on the first letter of product names

The following table lists the sorting and grouping specifications for this report. Product Name in the first row of the Field/Expression column in the Sorting And Grouping box groups the records by the first letter of the product names. Product Name in the second row sorts the records alphabetically by product name under each letter.

Field/ Expression	Sort Order	Group Header	Group Footer	Group On	Group Interval	Keep Together
Product Name	Ascending	Yes	Yes	Prefix Characters	1	Whole Group
Product Name	Ascending	No	No	Each Value	1	No

Notes

To print the first letter of each group in the group header, you use the Left function. For more information, click .
You can look at the Alphabetical List of Products report in the Northwind sample database. To view this report, open the Northwind database in the Samples subfolder of your Office folder, and then open the Alphabetical List of Products report in Design view. For information on opening Northwind, click .