Left Function in a query

[andytheit]

I am trying to use the left function in a query in Access 2003

left ([DESC],5).

I am entering it in expression builder but it keeps saying invalid syntax..

Also has anyone used Kaione's SprintDB Pro for pocket pc?
I am having trouble with that as well!!

Thanks for any help

Andy

 

[scorpio1769]

did you use the builder to write the syntax? What error message are you getting exactly?

 

[dhookom]

This might be a references issue. Check

http://www.accessmvp.com/djsteele/AccessReferenceErrors.html.

You should take your "SprintDB" question to a more appropriate forum.


Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[andytheit]

The error message is
"you omitted an operand or operator, you entered an invalid character or comma, or you entered text without surrounding it in quotation marks

 

[dhookom]

If you had copied and pasted from you query, I would not expect to see:

left ([DESC],5).

The l would be L and there would be no space between left and (.

What is your full SQL view?

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[PHV]

Some locales use semicolon:
Left([DESC];5)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886