function left() is not available in the query

F

Frankie

Hi,there,
I have a Access query as follows:

SELECT LEFT(MyTable.ItemNo,4) AS NewItemNo INTO NewTable
FROM MyTable;

But I got a error message when I execute it:

"Function is not available in expressions in query
expenssion 'Left(MyTable.ItemNo,4)'"

But it works well when I run it in another PC,I use
Access XP, any idea? thanks in advance!
 
M

Michel Walsh

Hi,



From within the VBE menu: Tools | References... You should see a list of references. One, that
is checked, should have its description starting with the word MISSING. Uncheck it.


Hoping it may help,
Vanderghast, Access MVP
 

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

Use In() Expression as Query criteria with guts from Function 1
Sudden problem with functions in queries 2
Undefined function 'Left' in expression 2
Left function 2
x percentile query 1
Can inner join be done on queries? 8
Undefined function 'Left' in expression 11
Left Join Query Problem 2

Top