Wednesday, April 6, 2011

Error 3075 in Select Query

Query gives Syntax error missing operator in query '[Relationship Manager]=John DOE'

BCA_Source = " SELECT distinct [Account Data Table less DTA CHD].BCA_ICA, " _
            & "[Account Data Table less DTA CHD].[Relationship Manager]" _
            & " FROM [Account Data Table less DTA CHD] " _
            & " WHERE [Relationship Manager]= " _
            & Me.cmb_Mngr.Value,

Thanks, Sury

From stackoverflow
  • Initial guess would be that Me.cmb_Mngr.Value has to be wrapped with escaped quotes.

    Joel Coehoorn : Of course, that wouldn't be an issue if he used a QUERY PARAMETER!

0 comments:

Post a Comment