Left function query error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

bkwilliams - 20 May 2008 08:46 GMT

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.

Reply to this Message

bkwilliams - 20 May 2008 09:11 GMT

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.

Reply to this Message

John Spencer - 20 May 2008 13:11 GMT

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

> 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.

Reply to this Message