Move a field in table Design view

1. Open the table in Design view.
   
   
2. Select the field(s) 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.

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.

Note   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. For information on how to change only the datasheet's column order, click .