Move a field in the design grid in a query or advanced filter

1. Open a query in Design view, or open a form or datasheet and display the Advanced Filter/Sort window.
   
   
2. Select the column you want to move.
   • 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.

   The displaced field and all fields to its right move to the right.