title: Suggestion about dealing with subqueries that need string analysis
body: <p>I need to create a query on the fly through VBA that get some strings from a table based on a set of criteria selected by the user . From the results of that first query I need to find the position of certain characters in the strings and only select the one that have the characters at a given position. This need to be done quickly as it then needs to be displayed in a combo box for the user to select before he runs a full other query.</p>
  
  <p>So my question is what is the fastest/best way to do this ? </p>
  
  <p>Should I put the result of the first query in a temporary table , analyze the strings from that table, delete the records that don't meet the selection and then run a query to display in the combo box from that table ?</p>
  
  <p>Thank you     </p>