MS Access Substring Function

Microsoft Access Substring function is mainly to extract the characters in the string. As we all know, the Substring function is not existed in Access, both in query or VBA Code. So how to extract the characters? Ms Access has several other functions that equivalent with the Substring function:   MS Access Substring LEFT Function

source http://database.access-templates.com/ms-access-substring-function.html