Error Diagnostic InformationODBC Error Code = 37000 (Syntax error or access violation) [Microsoft][ODBC Microsoft Access Driver] Extra ) in query expression 'status = 'Approved' and type = 'Market' and (rptdateend >= #2/4/2012 13:36:38# or rptdateend = null) and ((reportID=) or (reportID=))'. The error occurred while processing an element with a general identifier of (CFQUERY), occupying document position (149:17) to (149:61). Date/Time: 02/04/12 13:36:38 |