I am having problems using my Right function command.
I have a 12 digit number that if it equals 500 at the end of the number, I want another column to be updated with the first 9 digits of the number. To give specifics
Column A name is APComcode
Column B name is LUComcode
If Column A number ends with 500 I want Column B to be updated with the 9 digits to the right.
The formula I am using is : UPDATE TblComcode1 SET TblComcode1.LUComcode = Left([TblComcode1.APComcode],9)
WHERE (((Right([TblComcode1!LUComcode],3))="500");
The error message I am getting is Undefined function'Left' in expression.
I have a 12 digit number that if it equals 500 at the end of the number, I want another column to be updated with the first 9 digits of the number. To give specifics
Column A name is APComcode
Column B name is LUComcode
If Column A number ends with 500 I want Column B to be updated with the 9 digits to the right.
The formula I am using is : UPDATE TblComcode1 SET TblComcode1.LUComcode = Left([TblComcode1.APComcode],9)
WHERE (((Right([TblComcode1!LUComcode],3))="500");
The error message I am getting is Undefined function'Left' in expression.