Move a field

[Diane K]

I created a table in Access 2007 and I want to move a field to a different
place on the table. How can I do this without losing my data?

Thank you,
Dino

 

[Rick Brandt]

I created a table in Access 2007 and I want to move a field to a
different place on the table. How can I do this without losing my
data?

I can think of no scenario where this should matter, but open the table in
design view and then drag the field definition to wherever you want it.

 

[Diane K]

Thanks.

I can think of no scenario where this should matter, but open the table in
design view and then drag the field definition to wherever you want it.

 

[Joseph Meehan]

I created a table in Access 2007 and I want to move a field to a
different place on the table. How can I do this without losing my
data?
Thank you,
Dino

If you are in the habit of viewing or editing data in the table, you
should consider changing habits. Tables are designed to define fields and
hold data and they do that well. They can be used to display and edit data,
but they don't do that well. You are usually far better off using queries
forms and reports for those functions.