title: Why is this record count returning 1?
body: <p>In my MS Access DB I'm running a query in VB that should return two records. When I run it in SQL I get two records but when ran from VBA I get two. Here is the code in the SQL view which gets two records:</p>
  
  <pre><code>SELECT *
  FROM tblWebMeetingData
  WHERE [Last Name] LIKE 'Marx';
  </code></pre>
  
  <p>And when I call this in VBA like so:</p>
  
  <pre><code>SQL = "SELECT * FROM tblWebMeetingData WHERE [Last Name] LIKE 'Marx';"
  Set rst = CurrentDb.OpenRecordset(SQL)  
  MsgBox ("Number of records: " &amp; rst.RecordCount)
  </code></pre>
  
  <p>I get one record for number of records. Isn't record count suppose to count all the records returned from a SQL statement or table? What is it I'm doing wrong here?</p>
  
  <p>Thanks</p>