Truncating a field in a table help 1

[kswiss311]

Hello,

I am trying to truncate one field in a table, however the field size is variable (the character lengths 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

 

[PWise]

right(fieldname,4)

 

[kswiss311]

Thanks a lot, the different character size was throwing me for a loop and did not know if this function would work.

 

[kswiss311]

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

 

[PHV]

Like this (SQL code) ?
UPDATE yourTable SET [another column] = Right([one column], 4)

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886