How do I remove the last 6 charaters from the right side of the field? 2

[srossbach]

I am looking for a function in Access 2003 that will remove the last 6 charaters from a record.

Thanks

 

[Golom]

Try
[blue][tt]
myString = Left ( myString, Len(myString) - 6 )
[/tt][/blue]

 

[lespaul]

you mean from a field not a record?

UPDATE TABLENAME SET FIELDNAME = Left(FIELDNAME, LENGTH(FIELDNAME) - 6)


(**LENGTH may just be LEN**)




Leslie

 

[srossbach]

Thank you! Worked like a charm!