Undefined function in expression error

[Guest]

I'm getting an error when I try to run my query. I have a
field as an expression, "Vendor: Left([DESC],Len([DESC])-
21)" and Access apparently doesn't like it. The formula
works fine in Excel.

Dan

 

[Cheryl Fischer]

When the common, built-in functions produce errors, this is typically a
"references" problem. Here are two links with information on how to
diagnose and fix references:

http://allenbrowne.com/ser-38.html

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