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
 
Top