LEFT function do not work in 2007 quary?

crododo

Registered User.
Local time
Yesterday, 23:35
Joined
May 2, 2013
Messages
27
Hi,
In 2007 Access quary I can not use NEW_FILED: Left(tblAuthors.SURNAME, 3)
I am getting error Expresion you entered contains invalid syntax You Omitted on operand or operator, you entered an invalid charter or comma, or you entered text withour surroning it in quotations, marks.
Any ideas?
 
I found mistake, it should be ; insted of ,
 
, is the norm it is only in certain areas (countries) that ; is used.

Brian
 
hi

so if I make database on computer that hase croatian regional setting that meens it will not wok normaly when I install it on database with let say US setting?

Thanks for replay
 
I have never done that, but logic tells me that unless the system takes care of it somehow then yes there will be problems.

If I were to be in that position, and I never will having retired long ago, I would research portability.

Brian
 

Users who are viewing this thread

Back
Top Bottom