Add columns to existing table?

[Rick C.]

I have a table with 80 columns and with data already in it. I need to
add two columns IN FRONT OF the last two columns, then populate each of
those two columns with one space character. Is anything like this
possible right in Access? Thanks much.

 

[Fredg]

Rick,
It doesn't really make much difference where you add the new fields.
In Design view, add them to the end of the list, then select each and drag
each field where you want to.

Or, just add them to the end of the list, open the table in View, select the
column and drag it where you want it. Save the change.

Then again, what difference does it make what order the fields in the table
are displayed in?
A table is for storing data in, not for viewing.
If you want to view the data, use a Form, Query, or Report.
That's what they are for.
You have much more control over what is displayed, and how.

If you have many records, just run an Update query to update each record to
the spaces, or whatever you want.
Update YourTable Set YourTable.FieldName1 = " ", YourTable.FieldName2 = " ";

 

[Fredg]

Rick,
It doesn't really make much difference where you add the new fields.
In Design view, add them to the end of the list, then select each and drag
each field where you want to.

Or, just add them to the end of the list, open the table in View, select the
column and drag it where you want it. Save the change.

Then again, what difference does it make what order the fields in the table
are displayed in?
A table is for storing data in, not for viewing.
If you want to view the data, use a Form, Query, or Report.
That's what they are for.
You have much more control over what is displayed, and how.

If you have many records, just run an Update query to update each record to
the spaces, or whatever you want.
Update YourTable Set YourTable.FieldName1 = " ", YourTable.FieldName2 = " ";