MS Access Question how to trim a string

HIROYUKI TAMURA
HIROYUKI TAMURA used Ask the Experts™
on
How do I trim a tring in MS Access?
I want to remove last 4 letters on string.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Consultant and developer
Commented:
Left(yourString,len(yourstring)-4))
John TsioumprisSoftware & Systems Engineer

Commented:
Similar
Mid(YourField,1,Len(YourField)-4)

Open in new window

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial