T
Tennis Loving Programmer
Sorry about this simple question, but I am stumped. I am using the query
designer in Access 2003. I am trying to extract the leftmost 5 characters
from a text field.
Here is the entry from my query:
testme:Left([ZIPCODE], 5)
When I enter the function I get the following error message:
The expression you entered contanis invalid syntax. You omitted an operand
or operator, you entered an invalid character or comma, or you entered text
without surrounding it in quotation marks.
Any ideas? I think it looks right, but I am overlooking something I think.
Thanks!
designer in Access 2003. I am trying to extract the leftmost 5 characters
from a text field.
Here is the entry from my query:
testme:Left([ZIPCODE], 5)
When I enter the function I get the following error message:
The expression you entered contanis invalid syntax. You omitted an operand
or operator, you entered an invalid character or comma, or you entered text
without surrounding it in quotation marks.
Any ideas? I think it looks right, but I am overlooking something I think.
Thanks!