title: Store a single value in variable with SQL Select
body: <p>I have the following vba code. I am using MS Excel 2013. (I have an insert statement in this code as well, but I didn't copy this just to have a better highlight of my problem) </p>
  
  <pre><code>Dim cn As Object
  Dim cUserEmail As String
  Dim strSqlmail As String
  Dim rss As Object
  Dim strConnection As String
  
  Set cn = CreateObject("ADODB.Connection")
  strConnection = "Provider=Microsoft.ACE.OLEDB.12.0;" &amp; _
      "Data Source=C:\ActionList.accdb"
  
  strSqlmail = "SELECT [Email-Adress] FROM MyTable WHERE Name='Test'"
  
  Set rss = cn.Execute(strSqlmail)
  cUserEmail = rss.Fields(0).Name
  </code></pre>
  
  <p>At this point it stores the column name (Email-Adress) in my variable. Running the query in Access returns the column with only my desired value in it. </p>
  
  <p>I think I'm as good as finished, but I cannot seem to find how to get the value. When i change to rss.Field(1) it gives an error saying that the item cannot be found. </p>