Where problem

[ZOR]

Trying to add the last statement into the WHERE clause in query SQL page. It does not like the final ", and if I remove it my query produces nothing. Any ideas, thanks


((TXMASTERS.Competition) Like "*" & [FORMS]![Newquerysform].[LNAME5].[CAPTION] & "*"))


AND KEYWORDS.Keyword IN (" & Mid(strList1, 2) & ")"

 

[Crowley16]

try outputting the result of your generated sql once you've generated it.

I think you're missing quotes somewhere...

--------------------
Procrastinate Now!

 

[PHV]

in query SQL page
???
You posted something that seems VBA.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[ZOR]

Oh PHV, you are so, so right. Its VB. Now I have a problem where I have a multifield query that works (SQL) as recordsource for a listbox, that reacts/displays results on various list selections. But now the problem of how to integrate a VB part of the query (Multi select List) How do I climb over that wall? Thanks

 

[ZOR]

Now after hitting the last post/send button, I suppose I should have done it all in VB in the beginning. Think I have answered myself, but thanks both for comming in.