title: Error on recordset criteria depend if the key is text or numeric
body: <p>I need to extract some data from one table, in the same column I've number or text value.
  if I need to extract record until value 100% and I use this string:</p>
  
  <pre><code>Select count(TypeTrasp) as nr, 
  [DataAttesa KPI2-1] as Data FROM [db_Out$] 
  Where TypeTrasp = 'AOG' and [DGR] &lt; 1 group by [DataAttesa KPI2-1]`
  </code></pre>
  
  <p>I receive this error run-time '-2147217913 (80040e07)'</p>
  
  <p>With this string (text key) I retrieve the correct record: </p>
  
  <pre><code>select count(TypeTrasp) as nr, 
  [DataAttesa KPI2-1] as Data FROM [db_Out$] 
  Where TypeTrasp = 'AOG' and [DGR]= 'Out of Time' group by [DataAttesa KPI2-1]`
  </code></pre>
  
  <p>I know that in the text key I need to use 'xxx' but in the number key i can't.</p>
  
  <p>EDIT, I change field name from DGR to 2-1, below the sample of my excel table,
  the goal is cont record for each [2-1] criteria </p>
  
  <p><a href="https://i.stack.imgur.com/3WMPv.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/3WMPv.jpg" alt="table example."></a></p>