Move a column (MDB)

1. Open a table, query, form, view, or stored procedure in Datasheet view.
2. Select the columns you want to move.

   To select one column, click the field selector for that column.

   

   To select adjacent columns, click a column field selector and then, without releasing the mouse button, drag to extend the selection.

3. Click and hold down the mouse button in the field selectors again.
4. Drag the columns to a new position.

Note  If the columns don't move, they may be frozen, and you may have to unfreeze them.

Changing field order in table Design view changes the order in which fields are stored in the table and also changes the column order in the table's datasheet.

1. Open a table in Design view.
2. Select the fields you want to move.

   To select one field, click that field's row selector.

   To select a group of fields, drag through the row selectors of those fields.

   

   Row selectors

3. Click and hold down the mouse button in the row selector again. Microsoft Access displays a thin horizontal bar just above the last selected row.
4. Drag the horizontal bar to the row just below where you want to move the fields.

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.

   

   A selected column

   The pointer changes to a rectangle during the move