G
Guest
Hi
I'm having difficulty using the Left function in a Jet query. Other
functions, such as DatePart and InStr work fine in queries, but Left isn't
working. I checked my references, and they're all there.
Here's the sql:
SELECT Left([Client Numbers].[CMR Client Number],3) AS [CMR Number] FROM
[Client Numbers]
I keep getting the following error: 'Function isn't available in query
expression', and it lists the Left function above.
There doesn't seem to be a SUBSTRING function in Jet. Is there another way
to extract the first few characters of a string?
I'm having difficulty using the Left function in a Jet query. Other
functions, such as DatePart and InStr work fine in queries, but Left isn't
working. I checked my references, and they're all there.
Here's the sql:
SELECT Left([Client Numbers].[CMR Client Number],3) AS [CMR Number] FROM
[Client Numbers]
I keep getting the following error: 'Function isn't available in query
expression', and it lists the Left function above.
There doesn't seem to be a SUBSTRING function in Jet. Is there another way
to extract the first few characters of a string?