title: Query not returning rows on user input MS Access
body: <p>I am running below query in access in which i need to take argument from end user. Following query is used. However, when i don't ask for user input &amp; put the condition in the query like this (<code>tblApplications.txtApplicant Like "*dac*"</code>)  it returns values and as soon as i asked for user input it returns blank.</p>
  
  <p>Below is the query:</p>
  
  <pre><code>SELECT
      tblConstruction.txtConstructionNr AS [Constr-Nr] AS Amount,
      tblApplications.txtFolder
  FROM
      tblApplications
      LEFT JOIN tblConstruction
          ON tblApplications.IDConstAppli = tblConstruction.IDConstr
  WHERE
      (((tblApplications.txtApplicant) Like "*" &amp; [Please enter the applicant or parts thereof:] &amp; "*") AND
      ((tblApplications.txtDecission) Like "open"))
  ORDER BY
      tblApplications.txtApplicant,
      tblApplications.[txtKomm-Nr],
      tblApplications.txtDecissionDat DESC;
  </code></pre>