If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Undefine function?
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 |
#2
|
|||
|
|||
Undefine function?
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 CAM wrote: 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 -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...eries/200807/1 |
Thread Tools | |
Display Modes | |
|
|