Insert Column between existing columns?

[JC8865]

New member with a question about adding columns in Access2013,I'd like to add a column to an exisiting datasheet and place it between 2 existing columns,I see where and how to an a new column but don't see where I can insert it where I want it.


Any help or direction to a tutorial would be great..Thanks in advance.


JC

[June7]

Table in design view, right click > Insert Rows

or grab the row you want to move and drag it to the position you want.

Or use a query and explicitly select each field by name in the order you want to see them.

But why is this important?

Form in datasheet view, user can drag the fields (columns) into whatever position they want.

Form in Single or Continuous view (or a report), arrange controls as you want. Although this can be difficult if the controls are 'grouped'. Select all the controls > Right Click > Layout > Remove.

[JC8865]

Thankyou much for the reply and the information!


JC