trying to select the last 3 digits of a field

E

erick-flores

hello all

this is the query im using (I am looking to get the last 3 characters
of a field):

rep_code: Right(tablename.fieldname,3)

And I get this error:
IDBC--call failed
[Informix][Infomirx ODBC Driver][Informix]A syntax error has occurred.
(#-201)

Is it something wrong with my query or something outside Access 2003
(since the table I am trying to work with its using an ODBC conexion)?

Any ideas???


Thanks
 
Top