Undefined function 'Right' in expression

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
Back
Top