I am creating a Microsoft Access 2003 query. In the query I would like to convert a text field to a number. If I try to use the CONVERT function, I receive the error: "Undefined function CONVERT in expression". The data is from a linked SQL Server 2005 database table. The original SQL server database table can not be altered.
How to I convert a text field to a number type in an Access 2003 query?