Remove last character in string 1

[annsolomon]

This formatting stuff is going to be the death of me yet.

I'm trying to remove the last character of a text field called EmployeePercent. I've tried Left([EmployeePercent],-1) which clears the field entirely. Right([EmployeePercent],-1) which gives me a type conversion error. I've tried combining the Left and Right functions with the Len function.

Hopefully, I'll get the hang of this someday but I could sure use some help now.

Thanks. Ann

 

[danvlas]

Left([EmployeePercent],Len([EmployeePercent])-1)

Good luck

Daniel Vlas
Systems Consultant

 

[annsolomon]

Daniel, it works beautifully. Thanks a million! Ann