Cut last 5 character

[MN]

Hi,
What function can we cut (trim) last 5 char in a string?
Ex: I am a student in CA
After cut=> I am a student
Thank you in advance.
MN

 

[KARL DEWEY]

First make a backup copy of the table if you are updating the data.

Then use this ---
Left([YourField], Len([YourField]) -5)

 

[MN]

Thank you - thank ..... How smart you are
MN

First make a backup copy of the table if you are updating the data.

Then use this ---
Left([YourField], Len([YourField]) -5)

--
KARL DEWEY
Build a little - Test a little

Hi,
What function can we cut (trim) last 5 char in a string?
Ex: I am a student in CA
After cut=> I am a student
Thank you in advance.
MN