Expr: Left([dob],4) = omitted an operator?

  • Thread starter Thread starter Jan
  • Start date Start date
J

Jan

Getting error saying "omitted an operator" when trying a simple function.
All I'm trying to do is get a list of the first 4 characters of a text field
of 6 characters.

Expr: Left([dob],4)
 
Discovered the error, ";" was to be used as separator. Would be nice if the
help file included a little tip about that.
 
Discovered the error, ";" was to be used as separator. Would be nice if the
help file included a little tip about that.
Click to expand...

This is a locale issue: in some language-specific versions of Access,
such as the US English version, "," is the code delimiter. In some
European versions it's ";".

Unfortunately the Help files don't always treat this localization
issue correctly!
 
Back
Top