title: What is the quickest way to get a single value returned by ADODB.Recordset assigned to a variable?
body: <p>Sample Query:</p>
  <pre><code>RS.Open &quot;SELECT [Bike Model] FROM [Motorbikes$] WHERE [Bike ID] = 123&quot;
  Dim Bike_Model as String: Bike_Model = ???
  </code></pre>
  <p>This query is meant to return a single value but the Recordset seems to still be treated as multidimensional array. Is there a way to get a string returned instead? (Sorry if it's a dumb question, kind of a newbro at all this)</p>