Undefined function 'Right' in expression

J

JMacC

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

undefined function? 1
Problem with SET & REF function 0
Query error: Undefined function 'Concatenate' in expression 3
undefined function 'xxx' in expression - user function 2
undefined function UCase in expression 5
Function issue 4
undefined function replace in expression 2
Get unique values in expression builder 0

Top