Access 97 Query 3270 using Left function

[msnnews.microsoft.com]

Hello,
I have created a query which takes a stock location i.e "A01E" and
extracts the first and last character "A" and "E" to enable sorting at
level stage.
I use the Left and Right Functions i.e "Area:Left([Fieldname],1)" and
"Level: Right([Fieldname],1)".

This works perfectly on my local PC and I can also run it as an .MDE
But after I copy it to the NT4 Terminal Server whenever I try to run the
query it gives the following error :-

"Function isn't available in expressions in query expression
'Left([Locations]![location],1)'.

Any help would be very much appreciated.

 

[Arvin Meyer]

You have a missing reference on the NT4 Terminal Server. Open a code window
and go to Tools ... References and uncheck any marked as missing that you
don't need, then navigate to the proper file for any you do need. Most
likely the missing references on an NT4 machine are because the root
directory for the System32 folder is the WINNT folder and most likely
Windows on your local PC.

For more on references, visit the Access Web:

http://www.mvps.org/access

and Doug Steele's excellent resource:

http://members.rogers.com/douglas.j.steele/AccessReferenceErrors.html

--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

Hello,
I have created a query which takes a stock location i.e "A01E" and
extracts the first and last character "A" and "E" to enable sorting at
level stage.
I use the Left and Right Functions i.e "Area:Left([Fieldname],1)" and
"Level: Right([Fieldname],1)".

This works perfectly on my local PC and I can also run it as an .MDE
But after I copy it to the NT4 Terminal Server whenever I try to run the
query it gives the following error :-

"Function isn't available in expressions in query expression
'Left([Locations]![location],1)'.

Any help would be very much appreciated.