Undefine function?

[CAM]

Hello,

In Access 2007 I get this error message - Undefine function "Right" in
expression. There are 12 digits in the AccountNumber I just want to get the
8 digits only from the right. See code below, but in Access 2002 I don't
get this error message? Why and how do I fix this?


SELECT tblChartOfAccounts.AccountNumber, Right([AccountNumber],8) AS
AccountNumbered, tblChartOfAccounts.Description,
tblChartOfAccounts.CostCenter
FROM tblChartOfAccounts;


Cheers

 

[Chris O'C via AccessMonster.com]

Right is a function in the VBA library. One of your other libraries is
probably missing. In the code editor menu go to Tools > References. Do you
see a library shown as "MISSING"? Delete it and readd it, close the dialog
window and recompile.

If you don't see a "MISSING" reference, add a new library (doesn't matter
which one, just note which one it is), close the dialog window and recompile.
Open the references dialog window again and remove the library you just added,
then close the window again and recompile.

Chris
Microsoft MVP

Hello,

In Access 2007 I get this error message - Undefine function "Right" in
expression. There are 12 digits in the AccountNumber I just want to get the
8 digits only from the right. See code below, but in Access 2002 I don't
get this error message? Why and how do I fix this?

SELECT tblChartOfAccounts.AccountNumber, Right([AccountNumber],8) AS
AccountNumbered, tblChartOfAccounts.Description,
tblChartOfAccounts.CostCenter
FROM tblChartOfAccounts;

Cheers