Access 2002 change in field size

[Guest]

I have Access 2002 and have a table that I want to downsize the field size
from 11 (text) to 4 (text). Currently this field is populated with 11
characters. When I resize, I want to save the last 4 characters and NOT the
first 4 characters. Can someone assist me?

 

[Guest]

First Backup your data.

Use update query to update the field to four chr

UPDATE TableName SET TableName.FieldName = Right([FieldName],4)


And then change the field size to 4

 

[Guest]

First Backup your data.

Use update query to update the field to four chr

UPDATE TableName SET TableName.FieldName = Right([FieldName],4)


And then change the field size to 4

 

[Allen Browne]

Create a query using this table.

Change it to an Update query (Update on query menu.)
Access adds an Update row to the grid.

Drag this field into the grid.
In the Update row, enter:
Right([xxxx], 4)
replaceing xxxx with the name of your field.

Execute the query.

Verify the data is right.

You can then open the table in design view, and change the Field Size to 4.

 

[Allen Browne]

Create a query using this table.

Change it to an Update query (Update on query menu.)
Access adds an Update row to the grid.

Drag this field into the grid.
In the Update row, enter:
Right([xxxx], 4)
replaceing xxxx with the name of your field.

Execute the query.

Verify the data is right.

You can then open the table in design view, and change the Field Size to 4.