<div>
Try removing LIKE from keysql.<br />
<br />
Does that make any difference?
</div>


<div>
Will there always only be 2 values entered, or could it be any number?<br />
<br />
You probably need to SPLIT() the input value at &quot;;&quot;, and then loop over the array adding OR LIKE's to the WHERE clause to get to a final query.<br />
<br />

<hr />
»<b><i>bp</i></b>
</div>


<div>
How about this?<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42372607-1"><span>keysql = &quot;SELECT dbo_sys1_key_codes.key_code FROM dbo_sys1_key_codes Where key_code </span>
<span>LIKE ('&quot; &amp; Replace(Trim(Forms!Switchboard!key_sel), &quot;;&quot;, &quot;') OR LIKE ('&quot;) &amp; &quot;')&quot;</span>
</code></pre>
<hr />
»<b><i>bp</i></b>
</div>


<div>
@Norie - access throws an undefined function error if LIKE is not there<br />
@Bill Prew - it can be any number of values. &nbsp;Not sure I understand, the &quot;Or Like&quot;s get added in when the query runs.<br />
This is how the query that runs translates the criteria statement - &nbsp;<i><u><u>Like (Like '*2XH07' Or Like '*9XH16')</u></u></i>
</div>


<div>
Sorry, typo.<br />
<br />

<pre><code class="code-1 nolinks" id="code-20-42372609-1"><span>keysql = &quot;SELECT dbo_sys1_key_codes.key_code FROM dbo_sys1_key_codes Where key_code LIKE ('&quot; &amp; Replace(Trim(Forms!Switchboard!key_sel), &quot;;&quot;, &quot;') OR LIKE ('&quot;) &amp; &quot;')&quot;</span>
</code></pre>
<hr />
»<b><i>bp</i></b>
</div>


<div>
@Bill Prew - both statements throw a syntax error, saying there is a missing operator. &nbsp;The criteria is not being parsed correctly. &nbsp;It's translating as <br />
key_code LIKE ('*2XH07') OR LIKE ('*PXH16')
</div>


<div>
I think you need to use, as Bill suggested, Split to get an array of the values entered in the textbox.<br />
<br />
You could then use that array to create the criteria for your WHERE clause.
</div>


<div>
What and where is &quot;dbo_sys1_key_codes&quot; ? &nbsp;That sounds like a SQL Server table name rather than an Access one. &nbsp;Could you be doing a passthrough query or something? &nbsp;A little more context might help...<br />
<br />

<hr />
»<b><i>bp</i></b>
</div>


<div>
I guess I'm missing the point here. &nbsp;From what I can see, the criteria statement is generating correctly it's just that Access is formatting the LIKE statement. &nbsp;It's the initial Like( that is causing the problem. &nbsp;The &quot;or like&quot; operators get built in correctly.
</div>


<div>
the dbo table is an ODBC linked SQL table. &nbsp;We use Access as the front end tool. &nbsp;I have a switchboard form that users use to run preset queries. &nbsp;I was trying to simplify/expand the way that the users can enter criteria. &nbsp;Right now, the form is setup, rather inelegantly, with a number of text boxes that the users can enter one value into each, with or without wildcards. &nbsp;It runs fine, but they are limited to six variables. &nbsp;I could, I supposed just add a bunch more text boxes to make more choices available.<br />
<br />
I was just trying to streamline by giving them one text field to enter their variables in separated by semicolons, then using the above SQL statements to parse the stream and build the query. &nbsp;If you look at the question I linked, I originally got a solution which used an IN statement to create the query. &nbsp;That worked fine for one of the other reports because the data being used was specific. &nbsp;Now I decided to try to change over another set of queries that use data that needs to be wildcarded and I'm stuck again.<br />
<br />
I really tried many permutations of the SQL statement prior to reposting, but nothing is working.
</div>


<div>
For further context, the command button I'm using is setup like this to fire the query<br />
<br />
Private Sub Command275_Click()<br />
<br />
Dim Query As DAO.QueryDef<br />
<br />
Dim keysql As String<br />
<br />
keysql = &quot;SELECT dbo_sys1_key_codes.key_cod<wbr />e FROM dbo_sys1_key_codes Where key_code LIKE ('&quot; &amp;&nbsp;Replace(Trim(Forms!Switchb<wbr />oard!key_s<wbr />el), &quot;;&quot;, &quot;' or '&quot;) &amp;&nbsp;&quot;')&quot;<br />
<br />
Set Query = CurrentDb.QueryDefs(&quot;qry_m<wbr />ix_key_sel<wbr />ect&quot;)<br />
<br />
Query.Sql = keysql<br />
<br />
DoCmd.OpenQuery (&quot;qry_mix_key_select&quot;)<br />
<br />
End Sub
</div>


<div>
OK @Bill Prew and @Norie, that did it. &nbsp;Gosh I wish I was as smart as you people. &nbsp;I'd get more done a lot faster. &nbsp;OK splitting points?
</div>


<div>
Great, glad we sorted that out. &nbsp;Yes, fine for split for me, it was a collaboration...<br />
<br />

<hr />
»<b><i>bp</i></b>
</div>


<div>
<div class="content wysiwyg-content">
This is a continuation of a previous question (<a href="http://bit.ly/2yRemJp" rel="ugc">http://bit.ly/2yRemJp</a>).<br />
<br />
I have a textbox (key_sel) on a form (switchboard) that I want to allow the user to enter in a series of values separated by a semicolon, which will then be used as criteria in a query.<br />
<br />
SQL statement is below:<br />
&nbsp; <br />
keysql = &quot;SELECT dbo_sys1_key_codes.key_cod<wbr />e FROM dbo_sys1_key_codes Where key_code LIKE ('&quot; &amp;&nbsp;Replace(Trim(Forms!Switchb<wbr />oard!key_s<wbr />el), &quot;;&quot;, &quot;' or '&quot;) &amp;&nbsp;&quot;')&quot;<br />
<br />
If I use one value (*2XH07) the query runs fine and pulls the correct data. &nbsp;When I specify multiple criteria (I used *2XH07;*9XH16 as the value) it pulls no data. &nbsp;When I design view the query the query the criteria is below. &nbsp;Obviously the first &quot;Like &quot;&nbsp;is creating the problem. &nbsp;<br />
<br />
Like (Like '*2XH07' Or Like '*9XH16') <br />
<br />
Don't know what I'm doing wrong.
</div>
</div>


This is a continuation of a previous question (http://bit.ly/2yRemJp).

I have a textbox (key_sel) on a form (switchboard) that I want to allow the user to enter in a series of values separated by a semicolon, which will then be used as criteria in a query.

SQL statement is below:
  
keysql = "SELECT dbo_sys1_key_codes.key_code FROM dbo_sys1_key_codes Where key_code LIKE ('" & Replace(Trim(Forms!Switchboard!key_sel), ";", "' or '") & "')"

If I use one value (*2XH07) the query runs fine and pulls the correct data.  When I specify multiple criteria (I used *2XH07;*9XH16 as the value) it pulls no data.  When I design view the query the query the criteria is below.  Obviously the first "Like " is creating the problem.  

Like (Like '*2XH07' Or Like '*9XH16') 

Don't know what I'm doing wrong.

Using wildcards with a LIKE statement

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.