Table - Field Size Change

[Moxioron]

Hello all.

I have a seventeen digit field in a table that I want to trim down to fourteen. The date is led by three spaces. When I change the field size to fourteen it goes from right to left. How can I do it the other way..from left to right, so I can trim data on the front of the number?

Thanks for your help.

 

[Norie]

I wouldn't change the field size to trim data, try using an UPDATE query with the string functions Mid, Left, Right etc.

 

[alansidman]

See if this video helps you
http://www.datapigtechnologies.com/flashfiles/datamanipulate.html

Alan