title: Using SQL, how do I COUNT the number of results from a query?
body: <p>I'm quite new to SQL and coding generally. </p>
  
  <p>I have a SQL query that works fine. All I want to do now is return the number of rows from that query result. </p>
  
  <p>The current SQL query is:</p>
  
  <pre class="lang-sql prettyprint-override"><code>SELECT 
      Progress.UserID, Questions.[Question Location],
      Questions.[Correct Answer], Questions.[False Answer 1],
      Questions.[False Answer 2], Questions.[False Answer 3]
  FROM
      Questions 
  INNER JOIN
      Progress ON Questions.[QuestionID] = Progress.[QuestionID]
   WHERE 
      (((Progress.UserID) = 1) AND 
       ((Progress.Status) &lt;&gt; "Correct")
      );
  </code></pre>
  
  <p>I know I need to use </p>
  
  <pre><code>SELECT COUNT(*)
  </code></pre>
  
  <p>...though not quite sure how I integrate it into the query. </p>
  
  <p>I then intend to use OLEDB to return the result to a VB Windows Form App. </p>
  
  <p>All help is much appreciated.</p>
  
  <p>Thanks! Joe</p>