I'm attempting to run the following query:

SELECT Right([MEMBER].[MEMBERSHIP No],4) AS MEMNO FROM MEMBER;

When I do so I receive the following error:

Undefined function 'Right' in expression.

None of the string manipulation functions seem to work. Am I missing something?

(Note this is in Access 2002 on a converted Access 97 database, but is a new query)

Thanks
SJ

you have missing references, search here for answers on how to fix

Thanks for the reply. Searched the forum for "missing reference" and found a solution.