function left() is not available in the query

  • Thread starter Thread starter Frankie
  • Start date Start date
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!
 
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
 
Back
Top