Group records on an expression on a data access page

1. Open the data access page in Design view.
   
   
2. Create a grouped data access page.
   
   
3. If the expression will reference field names, either add the fields to the page as bound HTML controls, or add the fields as bound text boxes.

   Tip   The page will load faster in Page view and in Microsoft Internet Explorer if you use bound HTML controls.

4. Add a bound HTML control for the expression by clicking Bound HTML on the toolbox and then clicking in the section where you want the control.
   
   
5. Make sure the control is selected, and then click Properties on the toolbar to display the property sheet.
   
   
6. Type an alias for the expression followed by a colon and the expression you want in the ControlSource property box. In this example, FullName is the alias for the expression:

   FullName: FirstName & " " & LastName

7. With the bound HTML control still selected, click Promote on the toolbar.

   Microsoft Access adds a group header that contains an expand control, and a record navigation section that contains a record navigation control. Access moves the control you grouped on to the group header.

Notes

• Any field you reference in an expression must be added to the data definition of the page; The field is automatically added to the data definition when you create a control bound to that field. If you don't want to display the values in those controls in Page view or in Microsoft Internet Explorer, you can either hide the controls or delete the controls. Even if you delete a control bound to a field used in an expression on the page, it won't be deleted from the page's data definition.
  
  
• When you group on a control, Access creates an alias for the control by adding the prefix "GroupOf" to the control's name in the ControlSource property; for example, GroupOfFullName: FullName. When you reference this control in an expression or in a property, you must use the alias.