title: Access 2010 VBA query a table and iterate through results
body: <p>I have a query that I want to execute against a table. With the results I want to do something. In my head the pseudo code is:</p>
  
  <pre><code>var q = "select * from table where some condition";
  var results = db.getResults(q);
  foreach (row r in results )
      do something with result
  </code></pre>
  
  <p>How would I so something similar with vba? </p>