Error message on left function

G

Guest

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!
 
G

Guest

Tennis Loving Programmer said:
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!
Click to expand...
 
G

Guest

I solved this! I had changed my regional settings to change the field
seperator for an export I was doing, unknowingly causing this error too.
Thanks for the help.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Left function query error 2
invalid vertical bar 2
IIF Condition 5
DLookup syntax in control on form 7
Current Date in Query 12
Why doesnt this expression work =Format(Date(), "dd-mmm-yyyy" 1
Header problem (2) 1
How to display a field from a foreign table using DLookup? 2

Top