title: Store result of SQL count into a variable VB
body: <p>Im trying to get the result of an SQL statement and store it in an integer variable "count" in vb so it can then be displayed on my website showing the user the total Open records:</p>
  
  <pre><code>    SELECT COUNT (recordID) FROM [tbl_Records] WHERE [Status] = 'Open'
  </code></pre>
  
  <p>any help appreciated.</p>