SQL query

  • Thread starter Thread starter yohann
  • Start date Start date
Y

yohann

Hi
My problem is that i am trying to use the function Left in one of my query like
SELECT Left([Activity Season];1)
FROM
Table1

An error message's coming up : "function 'left' non recognized"
What could i do ?

Thanks a lot
Yohann
 
Usually this indicates a problem with your References. Go to any code window, and choose Tools>References from the menu. Uncheck any box that says MISSING and close the dialog box. This usually takes care of it. For more information, go here:
http://members.iinet.net.au/~allenbrowne/ser-38.html

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

Hi
My problem is that i am trying to use the function Left in one of my query like
SELECT Left([Activity Season];1)
FROM
Table1

An error message's coming up : "function 'left' non recognized"
What could i do ?

Thanks a lot
Yohann
 
Hi Yohann,

That should work.
(I assume that the ';' is a typo in your post?)

Left([Activity Season],1) is fine. - COMMA(,) not SEMI_COLON(;)

Anyway that would give you a syntax error, not a function not recoginized.

This query is tested and works on my PC:

SELECT Left([VALUE],1)
FROM TestData;

Are you running this query from Access itself, or are you calling it from
outside of Access (eg from a VB program) if this is the case, I know that a
lot of Access functions are not supported by the Jet database engine that
deals with this (though I though Left() was OK...)
If you are, what are you using to connect VB to the database file?

Is this all there is to it, or is this query part of somthing more
complicated?

is the error coming up when you run the query on its own, if you run the
application, or at design-time?

Give me a few more details and I'll see if I can help.

Cheers,

ChrisM

Hi
My problem is that i am trying to use the function Left in one of my query
like
SELECT Left([Activity Season];1)
FROM
Table1

An error message's coming up : "function 'left' non recognized"
What could i do ?

Thanks a lot
Yohann
 
Back
Top