need to truncatge string in access 2

[haytatreides]

i need to cut a string of length 10 down to length 6, cutting off the last 4 characters. any idea how to do this? will trim work on something other than whitespace??? help me please!!!

 

[TonyJollans]

Hi haytatreides,

If you just want to take the first six characters (of any length string) then ..

Left(String,6)

.. will do it. More generally to cut off the last 4 characters ..

Left(String,Len(String)-4)


Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.

 

[jrbarnett]

Hello

You can use the Left and Right functions to extract a specific length of a string at each end, or the Mid function to extract items from the middle.

John

 

[haytatreides]

thanks to u both. that did it