I am getting syntax errors any time I try to create a calculated field using ANY built-in function! Code as simple as this in the Expression Builder gets an error:
MyShortText: Left( [MyLongText] , 37)
I am thinking must be an environmental issue, but cannot figure it out.
Access 2010.
Am I missing something?
Help is most appreciated!