SQL ERROR
HejForneden har jeg min sql streng som give fejl meddelsen helt nede, og jeg kan ikke forstå hvorfor 1 at fejlen kommer og 2 hvorfor det sker omkring på midten af siden.
Jeg håber der er nogle smarte Søndags hoveder der kan hjælpe ?
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'.
