Undefined function 'Right' in expression

[Guest]

I moved an Access 2000 dbase to 2007. All queries using right() or left() in
the expression give the error message shown in the subject. when I use the
Expression builder and highlight the built-in functions, the bottom section
shows the function and that it has two arguments. When I paste or type the
function into the expression window, and highlight the function, it only
shows one argument?!!

What is going on?? Any help would be appreciated.

JIM

 

[Guest]

Probably a broken reference. Go to the following web page for information on
checking references:

http://www.mvps.org/access/bugs/bugs0001.htm