Hi
I have the SQL string below and the error I get at the buttom.
There are 2 things, the first is that the error point to the middle of the string and the second part what is the error as I think my string looks fine ?
Hope there are some bright people out there.
SELECT * FROM tblTaskTool WHERE (Project = 'SL - Activity Reporting' AND ([Status] <> '06) Completed' AND [Status] <> '89) Cancelled') OR (Project = 'SL - MLLP' AND ([Status] <> '06) Completed' AND [Status] <> '89) Cancelled') OR (Project = 'AB - MI Solutions' AND ([Status] <> '06) Completed' AND [Status] <> '89) Cancelled') OR (Project = 'AC - Sales and Marketing' AND ([Status] <> '06) Completed' AND [Status] <> '89) Cancelled') OR (Project = 'AC - Web Development' AND ([Status] <> '06) Completed' AND [Status] <> '89) Cancelled') OR (Project = 'AC - Infrastructure Support' AND ([Status] <> '06) Completed' AND [Status] <> '89) Cancelled') OR (Project = 'AC - Administration' AND ([Status] <> '06) Completed' AND [Status] <> '89) Cancelled') OR (Project = 'AC - Candalus Tool Dev' AND ([Status] <> '06) Completed' AND [Status] <> '89) Cancelled')
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '(Project = 'SL - Activity Reporting' AND ([Status] <> '06) Completed' AND [Status] <> '89) Cancelled') OR (Project = 'SL - MLLP' AND ([Status] <> '06) Completed' AND [Status] <> '89) Cancelled') OR (Project = 'AB - MI Solutions' AND ([Status] <> '06) Complet'.
I have the SQL string below and the error I get at the buttom.
There are 2 things, the first is that the error point to the middle of the string and the second part what is the error as I think my string looks fine ?
Hope there are some bright people out there.
SELECT * FROM tblTaskTool WHERE (Project = 'SL - Activity Reporting' AND ([Status] <> '06) Completed' AND [Status] <> '89) Cancelled') OR (Project = 'SL - MLLP' AND ([Status] <> '06) Completed' AND [Status] <> '89) Cancelled') OR (Project = 'AB - MI Solutions' AND ([Status] <> '06) Completed' AND [Status] <> '89) Cancelled') OR (Project = 'AC - Sales and Marketing' AND ([Status] <> '06) Completed' AND [Status] <> '89) Cancelled') OR (Project = 'AC - Web Development' AND ([Status] <> '06) Completed' AND [Status] <> '89) Cancelled') OR (Project = 'AC - Infrastructure Support' AND ([Status] <> '06) Completed' AND [Status] <> '89) Cancelled') OR (Project = 'AC - Administration' AND ([Status] <> '06) Completed' AND [Status] <> '89) Cancelled') OR (Project = 'AC - Candalus Tool Dev' AND ([Status] <> '06) Completed' AND [Status] <> '89) Cancelled')
Microsoft OLE DB Provider for ODBC Drivers error '80040e14'
[Microsoft][ODBC Microsoft Access Driver] Syntax error (missing operator) in query expression '(Project = 'SL - Activity Reporting' AND ([Status] <> '06) Completed' AND [Status] <> '89) Cancelled') OR (Project = 'SL - MLLP' AND ([Status] <> '06) Completed' AND [Status] <> '89) Cancelled') OR (Project = 'AB - MI Solutions' AND ([Status] <> '06) Complet'.