Search results

  1. G

    Sql equilivant to Val() Access function??

    Does anyone know of a function to return the numeric value of a string that contains some numeric and some non numeric chars. I need to replace some Val() Access functions with a sql equilivant. e.g. return 123 from the statement: SELECT Val(123mls) return 4.56 from the statement: SELECT...
  2. G

    "dbo." Table qualifier in Access Project on sql backend

    Can anyone help please? I have Access Projects on SQL 2005 backends. Some users are on Access2000, some are on Access2003 and some use Access2003 RunTime only. I have no problems with the Access 2003 full versions or runtimes. But with Access 2000 users, some can't use any forms or reports...
  3. G

    Upsizing Issues, Access to SQL Server

    I am upsizing a number of Access 2003 databases to SQL Server 2005 with Access Project front ends. My Access Tables all upsize OK, Some of the Queries upsize to SQL Views OK, Some Queries upsize to SQL Functions (WHY) and some get skipped completely. I have fixed up data type issues with...
Back
Top Bottom