Promote or demote a field, table, or query

Microsoft Office Access 2003

  • Open the data access page in Design view.
  • Do one of the following:

    To promote a field, select the field and then click Promote Button image on the toolbar.

    To promote a table or query, select a field that belongs to the table or query, and then click Group by Table Button image on the toolbar.

    To demote a field, select the field and then click Demote Button image on the toolbar.

    Note  When you demote a field, all other fields that belong to the group level get demoted as well.

  • ShowTip

    When you click Promote Button image, the selected control is moved to the next higher group level. To copy the field instead of moving it, press and hold the CTRL key when you click Promote on the toolbar.