title: How to run a loop of queries in access?
body: <p>I have a database with a table which is full of conditions and error messages for checking another database.</p>
  
  <p>I want to run a loop such that each of these conditions is checked against all the tables in the second database and generae a report which gives the errors.</p>
  
  <p>Is this possible in ms access.</p>
  
  <p>For example,</p>
  
  <p>querycrit table</p>
  
  <pre><code>id           query                                 error    
  1           speed&lt;25 and speed&gt;56              speed above limit  
  2           dist&lt;56 or dist &gt;78                dist within limit
  </code></pre>
  
  <p>I have more than 400 queries like this of different variables.</p>
  
  <p>THe table against which I am running the queries is</p>
  
  <p>records table</p>
  
  <pre><code>id   speed     dist    accce   decele   aaa   bbb     ccc
  1     33        34      44         33   33     33      33
  2     45        44      55         55   55     22      23
  </code></pre>
  
  <p>regards
  ttk</p>