Access 2002 change in field size

#1 (**permalink**) 28-Jul-2006, 08:09 AM

I have Access 2002 and have a table that I want to downsize the field size
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10090-access-2002-change-in-field-size.html
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?

*

#2 (**permalink**) 28-Jul-2006, 08:09 AM

First Backup your data.

Use update query to update the field to four chr
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10090

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

And then change the field size to 4

--
Good Luck
BS"D

"rlbaer" wrote:

> I have Access 2002 and have a table that I want to downsize the field size
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10090
> 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?

#3 (**permalink**) 28-Jul-2006, 08:09 AM

Create a query using this table.

Change it to an Update query (Update on query menu.)
Access adds an Update row to the grid.
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10090

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 - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"rlbaer" wrote in message
news:571B4362-3F16-4CF3-8126-D48BBD487FD7@microsoft.com...
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10090
>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?