Move a field in the design grid (MDB)

Microsoft Office Access 2003

Show All Show All

Move a field in the design grid (MDB)

Note  The information in this topic applies only to a Microsoft Access database (.mdb).

  1. Open a query in Design view, or open a form or datasheet and show the Advanced Filter/Sort window.
  2. Do one of the following:

    To select one column, click its column selector.

    To select more than one adjacent column, drag across their column selectors.

  3. Click the selector of any one of the selected columns again, and then drag the field or fields to their new location.

    Change the order of fields in a query by moving them

    Callout 1 A selected column

    Callout 2 The pointer changes to a rectangle during the move