Left function query error

[bkwilliams]

I am attempting to extract the first 2 digits of a 6-digit number in column
CX for a new column. I've entered the following for the query:

NEW:Left([CX],2)

but receive the following error msg: "The syntax of the entered expression
is not correct. You omitted an operand or an operator, you have entered a
character or an invalid comma, or text without delimiting it by quotation
marks"

This should be a straightforward operation, but I'm not sure where the
problem is. Thanks very much.

 

[bkwilliams]

The problem is solved...for some reason I had to replace the comma with a
semicolon. I'm using the French language version in Switzerland, for anyone
else who runs across a similar problem.

 

[John Spencer]

The separator character (comma or semi-colon or ???) is set by the Regional
and Language options control panel of the computer. In most European
countries that means the character is the semi-colon. In the US it is most
often the comma, unless someone has (unwisely) chosen to set it to something else.

John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County