Left([field],integer) function doesnt work. 1

[Slonoma]

Hi all,

I was hoping someone might know why the Left() function doesnt work in Access 2000, but does in Access97.

I have a query that is supposed to update a field, this query runs in Access 97, but when the database is opened in Access 2000(converted or not) I get an error message of "Function Left undefined" Here is the syntax:

UPDATE ShipmentDue SET Reference = Left([Reference], 6);

Thanks for any help

 

[BNPMike]

Left([Field14],2) works in Access 2000 in a select statement, so it must be something else that is upsetting it.

 

[jdegeorge]

How about trying WHERE instead of SET?

Jim DeGeorge

 

[mikevh]

If you open the VB Editor and go to Tools>References,
do you see any references marked MISSING? If so, make
a note of what the reference is, then uncheck it. Then
try your query again. See if this helps.

 

[Slonoma]

Thanks for the tips, I will try the VB Editor part this afternoon. As for the WHERE instead of SET, I need to UPDATE the table removing everything after the first 6 characters, so that will not work.

 

[GingerR]

i'd guess a REFERENCES error see this:

faq181-936

one thing to always try: you can search on error messages and their error numbers on line, at microsoft/technet and or sometimes i just put it (or partial error message) into Google search. usually something will turn up.