title: MS Query Excel to Access reserved word, misspelling or punctuation error
body: <p>I am new to SQL and I am trying to link my excel workbook (2010) to an Access database table (2010) using MS Query to return some summary statistics on our Fleet. I have a parameter for the month which is located in a cell in the excel workbook.</p>
  
  <p>The code I have is below and I get the error message </p>
  
  <blockquote>
    <p>The SELECT statement includes a reserved word or an argument name that
    is misspelled or missing, or the punctuation is incorrect.</p>
  </blockquote>
  
  <p>I have used the parameter for more simple information and it works perfectly, however, this code seems to be missing something.</p>
  
  <pre><code>SELECT tbl_FLEET_HISTORY.`Type`, 
  Sum(tbl_FLEET_HISTORY.`Number Railcars`) AS `QTY_Wagons`
  Sum(tbl_FLEET_HISTORY.`Number of Platforms: loading units`) AS `QTY_Platforms`
  Sum(tbl_FLEET_HISTORY.`Days Leased in Month`) AS `Days_Leased`
  Sum(tbl_FLEET_HISTORY.`Days Available`) AS `Days_Available`
  Sum(tbl_FLEET_HISTORY.`Daily Rate`) AS `Daily_Rate`
  FROM tbl_FLEET_HISTORY tbl_FLEET_HISTORY
  WHERE (tbl_FLEET_HISTORY.`Month`=?)
  and (tbl_FLEET_HISTORY.`Leased During Month`=`Yes`)
  GROUP BY tbl_FLEET_HISTORY.`Type`
  </code></pre>
  
  <p>I have run through a lot of the answers to this topic but I have not been able to resolve the issue. </p>
  
  <p>I would really appreciate any assistance. If there is any additional information needed please let me know.</p>