title: Search for a field that contains a string Access 07
body: <p>Earlier in the day I figured out the following query.</p>
  
  <pre><code>    SELECT DISTINCT Visits.KHA_ID, Visits.totalCharges
      FROM (Visits INNER JOIN (ICDTable INNER JOIN ICDVisitsJxn ON ICDTable.ICD9ID = ICDVisitsJxn.ICD_IDFK) ON Visits.ID = ICDVisitsJxn.VisitsIDFK) 
  INNER JOIN (ICDTable AS ICDTable_1 
  INNER JOIN ICDVisitsJxn AS ICDVisitsJxn_1 ON ICDTable_1.ICD9ID = ICDVisitsJxn_1.ICD_IDFK) ON Visits.ID = ICDVisitsJxn_1.VisitsIDFK
      WHERE (((ICDTable.Description) 
  Like "*[enter term]*") AND ((ICDTable_1.Description) Like "*[enter another term]*"));
  </code></pre>
  
  <p>This works the way I want it to.  I would prefer, however, if instead of having to type the exact text in the corresponding field that the user could search for a string of text.  This would be akin to the Like *word here* construct Access uses.  I've always hardcoded the substrings.  Anyone know how to do this programatically.  </p>