Originally Posted by theDBguy
Try Left$(). Sorry, I don't have a copy of Access 97 to find out which functions are available to you.
Now i try it in access 2016.
Left$ not help. From query wizard i see all this functions. Maby it can't be used with old mdb format?