In ms access, how can i extract all characters except the last 5 of non-uniform long string?

Combine the Left() function with the Len() function.





The Left() function takes two parameters, the first is the string, the second is how many characters to return.





Use the Length of your string - 5 as the second parameter of the Left() function to return everything but the last 5 characters.





Left(mystringvariable, Len(mystringvariable) - 5)





//




You should look at substr() and think about combining it with length()