title: Saving a SQL result that has multiple data being read from a Microsoft Access database
body: <p>I'm trying to send a email with multiple data from an SQL statement but I can't get the result of the SQL statement to be saved in the variable. </p>
  
  <pre><code> str = "SELECT Test.*,TestTopicScore.[Easy Question Score],TestTopicScore.[Medium Question Score],TestTopicScore.[Hard Question Score] from Test INNER JOIN TestTopicScore on Test.TestID = TestTopicScore.TestID ORDER BY Test.Score DESC"
  
   mycommand = New OleDbCommand(str, myconnection)
   myReader = mycommand.ExecuteReader
   myReader.Read()
   emailcontents = myReader("emailcontents")
  </code></pre>
  
  <p>The connection with the access database is fine and the data is read but i just cant get it to save in a variable.</p>
  
  <p>The error I get:</p>
  
  <pre><code>An unhandled exception of type 'System.IndexOutOfRangeException' occurred in System.Data.dll
  </code></pre>
  
  <p>Additional information: emailcontents</p>