|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 30th, 2004, 06:55 PM
|
|||
|
|||
Expr: Left([dob],4) = omitted an operator?
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) 
|
|
#2
May 30th, 2004, 08:07 PM
|
|||
|
|||
|
Left([dob],4) = omitted an operator?
Discovered the error, ";" was to be used as separator. Would be nice if the
help file included a little tip about that. "Jan" wrote in message ... 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)
|
|
#3
May 30th, 2004, 09:17 PM
|
|||
|
|||
|
Left([dob],4) = omitted an operator?
On Sun, 30 May 2004 21:07:35 +0200, "Jan"
wrote: Discovered the error, ";" was to be used as separator. Would be nice if the help file included a little tip about that. 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! John W. Vinson[MVP] Come for live chats every Tuesday and Thursday http://go.compuserve.com/msdevapps?loc=us&access=public
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
