Remove Last 3 Characters from Field Data (1 Viewer)

[dj_mix]

I trying to figure out how to remove the last 3 Characters from my data

Such as

MA-D-97
MA-09
UJS-KK-OL-20

Like the data to look like

MA-D
MA
UJS-KK-OL

I Have This so far

Right([TYPEFY],3)

that selects the last three now is there a remove function I can use??

Remove(Right([TYPEFY],3) ???

Need help thanks

 

[boblarson]

Left([TYPEFY], Len([TYPEFY]) - 3)

 

[RuralGuy]

Try Left([TYPEFY],Len([TYPEFY])-3)

 

[chergh]

try this

x = len(string)

left(string, x-3)

 

[dj_mix]

Very Nice I went with the majority

Left([TYPEFY],Len([TYPEFY])-3)

Thanks again