Truncating a field in a table, need suggestions

[Guest]

Hello,

I am trying to truncate one field in a table, however the field size is
variable (the character lengths of the records are 13, 14 and 15 characters
long). What I was wondering is how I would truncate this field in Access so
it takes just the last four characters?

Thank you,

Kent

 

[Allen Browne]

You want to lose everything in the field before the last 4 characters?

Use Right() in an Update query (Update on query menu, in query design.)

 

[Guest]

Do you want to update values in a field?
Do you want to modify values as users enter them into a form?
Do you want to create a column that displays only the last four characters?
Is this a one time task?
Is this a continuous task?
Is this a run on demand task?

 

[Guest]

Hello,

What I am trying to do after the truncation is populate the new truncated
records into another table. It will be a continuous task because the table
is updated with a import macro. Basically, the data on the file needs to be
truncated and stored in a new table upon being imported so it can be
displayed properly on a form. So I do want to create a new column with only
the last four characters just in a different table.

Hope this sheds more light on my situation Duane.

 

[Guest]

Did my previous post clarify things a little better as to what I am trying to
do?

Thanks, Kent

 

[Guest]

I was wondering how I would go about using this truncation method on one
column in a table and putting the truncated records into another column in
the same table?

Thanks, Kent