dexani
asked on
Funtion is not available in expressions in query expression
Please see the attached screenshot, we get this error when running a specific query from Access 2007 against a SQL Server 2008 database located on the same machine that Access is located.
Think this also relates to another question that I have open at the following location :
https://www.experts-exchange.com/questions/28109815/Conversion-failed-when-converting-date-and-or-time-from-character-string-241.html
Any assistance will be greatly appreciated.
screenshot.png
Think this also relates to another question that I have open at the following location :
https://www.experts-exchange.com/questions/28109815/Conversion-failed-when-converting-date-and-or-time-from-character-string-241.html
Any assistance will be greatly appreciated.
screenshot.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
In general, you should always post the full SQL.
It is difficult to troubleshoot a generic query error without seeing the SQL...
It is difficult to troubleshoot a generic query error without seeing the SQL...
Scott C