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