I used a RunSQL statement like the following in Access97, but Access2K does not like the Left and Right functions? It says they don't exists... Is there a replacement or am I going crazy?
Docmd.RunSQL "SELECT [EN], (Left([EN],6) & Right([EN],4)) AS ESMA INTO [New Table] FROM [Old Table];"
This worked in Access97...Why does Access2K not like the Left and Right functions. Even the next statement is coming up with an error.
Docmd.RunSQL "UPDATE [New Table] SET [ESMA] = Left([EN],6) & Right([EN], 4);"
Mike
Docmd.RunSQL "SELECT [EN], (Left([EN],6) & Right([EN],4)) AS ESMA INTO [New Table] FROM [Old Table];"
This worked in Access97...Why does Access2K not like the Left and Right functions. Even the next statement is coming up with an error.
Docmd.RunSQL "UPDATE [New Table] SET [ESMA] = Left([EN],6) & Right([EN], 4);"
Mike